Connection to Azure SQL database is failing with "unable to connect to port 1433" message

Magnitude Software 0 Reputation points
2023-04-17T14:39:20.28+00:00

From my machine I am able to connect Azure SQL DB using SQL Server Studio and microsoft libraries. However, When I use a replication software along with the driver provided by the replication software, it fails stating that "port 1433 is not accessible"? Same is the case with another 3rd pary connectivity driver. I have entered my machines's IP in firewall rule. not able to figure out what else need to be modified / configured for this connection to happen? appreciate the help in advance. Thanks,

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,986 Reputation points MVP
    2023-04-17T15:03:49.3366667+00:00

    Maybe that software is not compatible with Azure or it has issues with the setting required to connect Azure SQL. Make sure the replication software allows you to configure the connection string to set Encrypt Connection to Yes and to set Trust Server Certificate to Yes.

    Azure offers a free tool named Azure SQL Data Sync that may be more easy to use and set for you.

    Another great tool on the market is SymmetricDS.

    0 comments No comments