Hyper-V SQL can't connect.

JoeW 0 Reputation points
2024-02-23T16:37:11.2466667+00:00

I created a Windows 2022 Server VM and Installed Microsoft SQL Server 2022 Standard on that VM. From that VM I can access the SQL server from SSMS without any issues. I cannot however access the SQL server from my desktop. The Hyper-V host machine, the SQL VM and my desktop are all on the same domain and network. I have enabled tcp, remote access, I can ping the server by both name and IP address. And to eliminate ports being blocked I temporarily disabled the firewall on the Host, VM and my desktop yet I still get "The wait operation timed out". I then built another Windows 2022 Server VM and installed SSMS on it and I could get that the SQL server from that VM. I then downloaded and ran PortQueryUI from my desktop and UDP port 1434 and TCP port 1433 come back as FILTERED. yet they are listening on the SQL server. I feel like I have addressed everything that could cause connection failures, am I missing something?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,208 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,613 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. JoeW 0 Reputation points
    2024-02-23T18:06:14.3433333+00:00

    Hopefully this will help, here's the details when I try and connect from my desktop using SSMS, I've also tried both Windows and SQL authentication, same results.

    ===================================> Cannot connect to MWDB.> ===================================> 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=29306; handshake=26230; (.Net SqlClient Data Provider)> ------------------------------> For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476> ------------------------------> Server Name: MWDB> Error Number: -2> Severity: 11> State: 0> ------------------------------> Program Location:> at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)> at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)> at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)> at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)> at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)> at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)> at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)> at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)> at System.Data.SqlClient.SqlConnection.Open()> at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)> at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()> ===================================> The wait operation timed out>

  2. Christian Lesjak 0 Reputation points
    2024-06-04T14:22:02.96+00:00

    Is there an update?

    i have exactly the same issue?

    informations would be appreciated!

    0 comments