What are the challenges you face when working across database platforms? Take the survey
Options

Linked server compare (with SQL Server Native driver)

cupbadocAwv8cupbadocAwv8 Posts: 2
edited December 14, 2010 2:35PM in SQL Compare Previous Versions
Hello,

What is the correct way to compare a local database with a linked server? We tried every possible way without success. The linked server use native sql server type. We currently use 8.1.0.360 version of sql compare 8.

When we set the right database name to [10.1.1.1\PROD].[ProdDB] and try to compare we get the following error message:
Cannot open [10.1.1.1\PROD].[ProdDB] requested by the login. The login failed. The same login works fine when we list or use the same database server.

Regards,
cup

Comments

Sign In or Register to comment.