Linked server compare (with SQL Server Native driver)
cupbadocAwv8
Posts: 2
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
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
As long as [10.1.1.1\PROD].[ProdDB] is an online SQL Server database, then you should be able to connect to it to compare. Are you able to connect using the same credentials with SSMS?
Can you also check the following document, to make sure your user account has the necessary permissions.
http://www.red-gate.com/supportcenter/C ... quired.htm
I hope this helps.