error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?

error while generating ad hoc model for Analysis Services Cube

hi,

I try to generate ad hoc reporting model for analysis services cube in reporting services.
in Management Studio I connected to reporting services, defined a data source to the analysis services database.
But If i try to generate model i get the error:
"While connection with a data source a mistake has appeared, or the query is invalid for the data source. (rsCannotPrepareQuery)(Report Services SOAP Proxy Source)"

Any ideas as to what may be the problem?
Thanks!

karaman

Moving to Reporting Services forum.|||I am having the same issue and can find no other reference to it, anywhere. Did you get this resolved?

Error while connecting to analysis services data source from reporting services

I am trying to connect to an analysis services data source from reporting services.

Analysis services is on a different domain. When I try to run the reports I get the error

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https. "

Any ideas on what is the workaround?

Try this:

on the reporting server, create a user ie. report and in IIS let the Reports and Reportserver run as the report user you just created. On the Analysis server, create that same user with the same password. Add that user to the Analysis cube. Thats it.

I have added my report user on the domain and also locally on the server. I don't think you need the user in both places but you can test as a local user as see what happens

|||When I modified the user in the report server application poll, I'm getting "service unavailable" error when connecting to reports|||

Leave the app pool as Network Service,

In IIS, Report/Reportserver properties ->directory security, check enable anonymous access and type in your user name and password

Error while connecting Analysis Manager

Hi,

I try to connect a distant analysis manager server. My user is declared as Administrators in the distant server. I'm Administartor too on my PC

When I try to connect this server (via IP adress) a error appears :

Cannot connect to the repository

Analysis server : ip adress here

Error:
'\\<nameOfDistantServer>\MSOLAPRepository$\msdrep.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on wich the file resides.

Someone can help me ?

Thanks

moustachuRefer to the registry for the key [HKLM\Software\Microsoft\OLAP Server\Server ConnectionInfo\RemoteRepositoryConnectionString] and edit the value with the valid path.|||I will try as soon as possible

Thanks