Unable to connect to SQL Azure with SSMS, LinqPad; SQLCMD works fine
I have been using SSMS and LinqPad both for months to connect to SQL Azure instances without issue. Suddenly this week, linqpad stopped connecting, consistently timing out and displaying this error message: "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - the wait operation timed out.)"
At first, it was just LinqPad. But soon after I started experiencing the same issue with SSMS 2012. It showed the exact same error message (slightly different dialog).
I've confirmed that this isn't a firewall rule issue. My IP has been allowed through the SQL firewall for months, and I can still connect using the same credentials using SQLCMD and I can run queries.
Any ideas? Why would SSMS and LinqPad both take a big dump while SQLCMD still works?
I finally found the solution to this (I think I may have found it via https://stackoverflow.com/questions/13420770/pre-login-handshake-error-connecting-directly-to-sql-azure). I installed some completely unrelated software about the time that things stopped working. As it happens, said software also installs - silently - some bundled software that leaves you with custom Winsock LSPs in place, which means the system is then afflicted by an issue reported to Microsoft and addressed in KB 2568167. Fortunately, I didn't have to manually remove the LSPs because I was able to uninstall the unwelcome software (Sendori!).
- How to show full definition of function or procedure?
- What is the maximum number of connections for a SQLite3 database?
- MySQL: Cloning a MySQL database on the same MySql instance
- How can I get partial participation of both entities in 1:1 relationship
- Fixing all sequences in PostgreSQL 15 after migrating with logical replication from PostgreSQL 11
- What are the main differences between Redis/Valkey Pub/Sub and Streams?
- How to retrieve the last autoincremented ID from a SQLite table?
- All data is become NULL when run Update Query MySQL
- Execute SQL from file in SQLAlchemy
- How can I write a trigger and function to insert data into table2 when a new row is inserted into table1, while avoiding duplicates in table2?
- Using Django to visualise scraped data
- i'm having trouble creating the database using symfony framework
- Display data from state with React Typescript
- Find gap between values of the same type in sql
- How Connect to multiple collections in Mongoose?
- Django database connections pool with psycopg2.pool
- How to generate the whole database script in MySQL Workbench?
- postgresql: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
- The right place to host shared tables between WordPress web site and mobile apps
- How to represent optional attributes in an ER diagram?
- UUID vs Long primary key
- How can I get column names from a table in Oracle?
- How can I create database tables from XSD files?
- How to build a database from an XSD schema and import XML data
- Handle ORA-00947 and Continue Execution in PL/SQL Package
- How can i name a variable based on a file name?
- Why does a database table expressing all possible combinations of values of 2 attributes violate 4NF?
- Database (database/database.sqlite) does not exist. Database works from artisan tinker
- What is the exact location of MySQL database tables in XAMPP folder?
- How do multi user applications use databases?