Error: Tcp Provider: Error Code 0X2746. During the SQL Setup in Linux Through Terminal

08S01: ODBC Driver 17 for SQL Server; TCP Provider: Error code 0x2746 (10054)

It appears Microsoft added some new firewall settings to Azure SQL Server.

By default, these new firewall settings disabled public access => ODBC could not connect to the DB.

I manually reset them to the following values and the tests started working again:

azure sql settings

SQL Server ODBC TCP Provider: Error code 0x274C

Error code 0x274C (10060)

Explanation

The SQL Server client cannot connect to the server. This error could
occur because either the firewall on the server has refused the
connection or the server is not configured to accept remote
connections.



Related Topics



Leave a reply



Submit