Cannot connect to SQL Azure with LinqPad 8
The database I am working with has been migrated from SQL to Azure SQL. Since then I am unable to connect to it from LinqPad, although I have no issue with SSMS.
Here is the error message I am getting:
8.5.5 (X64) 2024-09-19T17:47:10.0105870+02:00 Error opening DataContext
SqlException - Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=33; handshake=14968;
Source=Core .Net SqlClient Data Provider
InnerException=Win32Exception
Any ideas about how to fix this?
Comments
-
This sounds like an authentication error. Are you using the right credentials?
Also, do you get the same result when you use LINQPad's LINQ-to-SQL driver?