SSDT Data comparison, login failed

3
votes

When ever I try to proceed to the second step in the comparison, it displays a message saying that it cannot connect with the login I provided (sqlAuth not win).

Note A: It will let me run queries and even do a schema comparison, but no luck with data comparison.

Note B: localhost works fine.

Versions:

Remote:

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)

Local:

Microsoft SQL Server 2014 (RTM-CU14) (KB3158271) - 12.0.2569.0 (X64) May 27 2016 15:06:08 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.3 (Build 10586: )

2
sql-servervisual-studio-2015sql-server-data-tools
What is the exact error you are getting? - SS_DBA
The generic "login failed for user". - Slime recipe
I'm having a similar problem, except schema comparisons are not working for me. - StuartQ
@StuartQ I haven't as it is now seems to work okay for some bizarre reason. anyway, if you haven't, try to give a shot to James answer as it seems to lead to a useful link supported by the SSDT team. - Slime recipe
It's now working for me. I attempted a reinstall (was already on the latest version), but it may simply have been restarting VS that did the trick. - StuartQ

2 Answers

3
votes

There have been a number of connection-related fixes in the latest SSDT 16.5 release. I just worked through a similar issue with a partner building SSDT demos, and updating to latest resolved issues in Data and Schema compare for SQL Authentication with them. Specifically, there were issues where the "Remember Password" checkbox wasn't preserved which was causing issues, so you may need a one-time action to enter the password so that it's re-saved correctly.

Disclosure: I work on the SQL Server tools team.