Menu

TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server
📰

TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server

DEV Community: database·Kausar Raza·10 days ago
#aBKTCe8W
#devtodatabase#devto#dev#server#port
Reading 0:00
15s threshold

We moved this site's database to a new SQL Server, and the first time I tried to connect from my own PC, sqlcmd sat for a few seconds and then printed this:

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: The wait operation timed out. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.

Enter fullscreen mode

Exit fullscreen mode

The connection string was right, the password was right and the server was running - the website was using it at that very moment. The problem was one layer below SQL Server: the new host's firewall was silently dropping connections from my IP address. The next day the same error came back, because my home internet connection had been given a new IP.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.