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?