SQL Server doesn't exist or access is denied
Published 13 December 2022
SQL Compare can't connect to the SQL Server. Try the following to rectify the problem:
- Verify that the SQL Server is online and that the SQL Server name is listed in your LAN by pinging the address.
For example, open a command prompt and run the following command:
ping <ServerName>
where ServerName is the name of your SQL Server.
If the SQL Server is online, verify that you are connecting to the correct port.
If your SQL Server is not running on the default port (1433), type the following in Server on the Project Configuration dialog box:
<ServerName>,<Port>
where ServerName is the name of your SQL Server and Port is the number of the port on which your SQL Server is running.
For example:
If you are sure that you are connecting to the correct port, force SQL Compare to use the TCP network protocol when it makes the connection, by typing the following in Server on the Project Configuration dialog box:TCP:<ServerName> For example: