Hello all,
We are running SQL Server 2000 SP4 with Analysis Services on Windows 2003 Server Standard Edition with SP1. This is a test server, also running IIS and SharePoint Services. The repository has been migrated to SQL Server. We receive an error when connecting to the server (locally) from Analysis Manager:
Cannot connect to the repository.
Analysis server: servername
Error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

If I edit the repository connection string with Analysis Manager, both Local and Remote fields are blank. If I set the values, I can connect, however, the values are not being saved. The registry keys
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Server Connection Info\Repository Connection String" and "RemoteRepositoryConnectionString" do not retain the connection string. Once I exit out, I have the problem again. I ran REGMON (from SysInternals) but never saw an attempt to set the registry value when I editted the connect string in Analysis Manager. A similiar connection string works on other systems. The account I'm using is in the Administrators and OLAP Administrators groups. If I use the MDX Sample Application (Server: servername, Provider:MSOLAP), it can connect to the FoodMart database and return data. MDAC ComponentChecker says I'm using MDAC 2.8 SP2.
Any ideas on what could be causing the problem? I've looked for DLL conflicts, but haven't found anything.

Thanks.

Hi there,

I'm having similar issues, did you manage to find a solution? I'm running Analysis Services SP4 on an XP SP1 workstation.

The repository connections strings are set correctly if the MSSQLServerOLAPService is logging on as 'LocalSystem' but this is useless as the SQL Server 2000 database is located on a separate machine.

Thanks

I've finally managed to fix this issue.

When Analysis Services SP4 was installed and I was logged onto the 'MSSQLServerOLAPService' service as 'LocalSystem', the problem occurs. i.e. when I then try and Log onto the service as a domain account, the Local and Remoted Repository Connection Settings are blank when you try to edit them (you cannot edit them in the Registry as they've been encrypted as of SP3 - read the section on migrating the repository in the MS Operations guide: http://www.microsoft.com/technet/pro.../anservog.mspx). This generates the error here when you try and register/connect to the Analysis Server.

I uninstalled Analysis Services and then re-installed the initial version of AS (where the Registry Keys are unencrypted). It is then possible to log on as a domain account and connect to the Analysis Server. Leaving the service logged on as domain account and then installing SP4 fixes the problem.

Its only wasted a week of my time...