Error message when connecting to database.

DTS Package Compare 2

Error message when connecting to database.

Postby Maxim » Tue Apr 18, 2006 9:25 pm

I've just installed DTS Package Compare 2. When I try to perform comparison, Loading Packages information fails and I am getting following error: Unable to load package information from local storage or meta-data services on SQL Server instance 'SERVER1\\INSTANCE1'. Refer to messages for more details. Ensure you have access to the server.
SQL Compare and SQL Data Compare works fine from same machine. Please advise.

Regards,
Maxim
Maxim
 
Posts: 3
Joined: Tue Apr 18, 2006 6:27 pm

Postby Brian Donahue » Thu Apr 27, 2006 5:11 pm

Hello Maxim,

Hopefully there is some more information, either in the error text or in the application event log.

A common cause of this problem would be if your login didn't have access to the MSDB database.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to DTS Package Compare 2

Who is online

Users browsing this forum: No registered users and 0 guests