SQL Server ODBC "TCP Provider: Error code 0x274C"

user_8626917 0
Viewed 6811

I got the following error from the ODBC Driver 17 for SQL Server:

[08S01] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x274C (10060) (SQLExecDirectW)

I can tell from this documentation on the SQLSTATE values for ODBC that the 08S01 indicates that the issue was a "communication link failure", but I'm having trouble finding documentation that indicates the meaning of TCP Provider: Error code 0x274C and so I don't know whether this gives more specific information about the failure.

What does the 0x274C error code mean?

odbc sql-server
2 Answers

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.

user_124036120

I faced the same connection issue. I was able to connect to a remote MSSQL server using DB Weaver but facing issues when trying to connect using file. If you're using multiple php versions, please remove all unwanted versions.

sudo apt-get purge php5.*
sudo apt-get purge php5.6  #specific version

restart apache2 or nginix server php sudo service php7.4-fpm restart

user_14689000
Related