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

Linked server compare (with SQL Server Native driver)

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

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 version of sql compare 8.

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



Sign In or Register to comment.