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.…