CODEWITHSUNDEEP
sql-serverredgate
Ali EXE
Ali EXE

Reputation: 1361

Redgate SQL Compare is not connecting to the target server, though SQL Server Management Studio connects

I'm using Redgate SQL Compare to compare my databases.

I can connect to my server's database using my local SSMS. I can also test it successfully using connection.udl file.

However, even when I use SSMS plugin to compare a local database with a server database, redgate's SQL Compare complains that:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - Access is denied.)

What might be wrong?

Upvotes: 0

Views: 733

Answers (0)

Related Questions