Microsoft KB Archive/328718

= How To Troubleshoot a &quot;Can't Connect to Repository&quot; Error Message =

Article ID: 328718

Article Last Modified on 8/30/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



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 \Program Files\Microsoft Analysis Services\Bin\Msmdrep.mdb. By default, Analysis Server stores the user's data for cubes and dimensions in the \Program Files\Microsoft Analysis Services\Data\  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 &quot;Deploying Commerce Server Using Windows Authentication, Step 10, Setup the OLAP database,&quot; in the product documentation. The registry key is. 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



Additional query words: Analysis Server Repository OLAP

Keywords: kberrmsg kbhowto KB328718

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.