Thursday, March 22, 2012

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.


While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

No comments:

Post a Comment