How To Troubleshoot a "Can't Connect to Repository" Error Message (328718)


The information in this article applies to:

  • Microsoft Commerce Server 2002
This article was previously published under Q328718

SUMMARY

When you try to run a Data Transformation Services (DTS) package, or you try to unpup the data warehouse resource, you may receive the following error message in the event log:
Event ID 45057 - cannot connect to repository.

MORE INFORMATION

  • Verify that you can view the Analysis Server. To view the analysis server databases and the folders (data sources, cubes, shared dimensions, mining models, and database roles), open the Microsoft Management Console (MMC), locate the Analysis Server snap-in, and then click the server name.
  • If the Analysis Server repository has not been migrated to a computer running SQL Server, the metadata repository information is located at System Drive\Program Files\Microsoft Analysis Services\Bin\Msmdrep.mdb.
  • By default, Analysis Server stores the user's data for cubes and dimensions in the System Drive\Program Files\Microsoft Analysis Services\Data\Analysis Server Database Name folder.
  • You can migrate the OLAP repository to increase its security. You can only do this by using a migration wizard. For more information, see "Deploying Commerce Server Using Windows Authentication, Step 10, Setup the OLAP database," in the product documentation.
  • The registry key is HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Server Connection Info\Repository Connection String. If the metadata has not been migrated to a computer running SQL Server, the value is the following (or similar):

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

    If the metadata has been migrated, the value is the following (or similar):

    Provider=SQLOLEDB.1;Password=sa_Password;Persist Security Info=True;User ID=sa_UserID;Initial Catalog=OLAP_Database; Data Source=LAB2R3_5;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LAB2R3_5; Use Encryption for Data=False;Tag with column collation when possible=False

Modification Type:MinorLast Reviewed:8/30/2004
Keywords:kberrmsg kbhowto KB328718
©2004 Microsoft Corporation. All rights reserved.