20,212 questions
if port 1433 is open, you are probably trying to connect to a named instance which requires Port 1434 on UDP to be open.
SQL Server 2022 - Unable to connect remotely via SMSS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 79%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Derek Gilmore
0
Reputation points
I am currently experiencing an issue connecting to my SQL server via SMSS installed on a Windows 11 machine. I am able to both ping the IP and hostname of the SQL server and telnet to the machine on 1433. I have verified that TCP is enabled in the SQL server configuration. However when attempting to connect with SQL Studio receive the following error:
TITLE: Connect to Server
------------------------------
Cannot connect to <HOSTNAME>.
------------------------------
ADDITIONAL INFORMATION:
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.) (Microsoft SQL Server, Error: 258)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-258-database-engine-error
------------------------------
The wait operation timed out
------------------------------
BUTTONS:
OK
------------------------------
I have verified that locally on the SQL Server I am able to connect with SMSS without issue. I have attempted increasing the timeout for the connection and this did not help resolve the issue. This occurs if I am using Windows Auth or SQL Auth
Windows for business Windows Server User experience Other
SQL Server Other
14,494 questions
{count} votes
-
Dan Guzman 9,401 Reputation points2024-02-06T19:37:01.5066667+00:00 Try adding
TrustServerCertificate=trueto the connection string. -
Dan Guzman 9,401 Reputation points
2024-02-06T19:56:01.9633333+00:00 In SSMS, click the Options button and check the "Trust Server Certificate" check box in the connection properties.
-
Derek Gilmore 0 Reputation points
2024-02-06T20:34:53.1833333+00:00 There is no change in the behavior with the box ticked or not.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2024-02-06T22:14:39.14+00:00 What does the properties look like when you right-click the Protocols node for instance under SQL Server Network Configuration? Are all No like mine?
-
Derek Gilmore 0 Reputation points
2024-02-07T14:24:29.52+00:00 That is correct Erland, the settings on my SQL server are the same as yours as shown below:
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2024-02-06T23:09:17.5533333+00:00 -
Derek Gilmore 0 Reputation points
2024-02-07T14:34:59.5666667+00:00 Just did a check on the SQL box for active listening ports and got the following, so it does not appear to even be listening on UDP 1434
TCP 127.0.0.1:1434 HOSTNAME:0 LISTENING TCP [::1]:1434 HOSTNAME:0 LISTENING -
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2024-02-07T22:20:03.8433333+00:00 Well, since Derek obviously reaches SQL Server it is not a simple case about opening the ports that SQL Server uses in the firewall.
But what is going on, I frankly do not know, least of all since Derek says that the same thing happens with SQL authentication. (Else I would have suspected the communication with the AD.)
Maybe there is some other communication SQL Server wants to do and where there is a firewall. But what that would be - no idea.
-
Derek Gilmore 0 Reputation points
2024-02-08T16:45:15.41+00:00 Is there anyway to determine the process behind the SSL provider for SQL?
Sign in to comment -
-
ZoeHui-MSFT 41,491 Reputation points2024-02-07T06:18:05.4766667+00:00 Hi @Derek Gilmore,
Timeout Settings
Adjust timeout settings to accommodate any network latency.
In addition, named instances use dynamic ports by default. You may need to change the firewall rule.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
-
Derek Gilmore 0 Reputation points
2024-02-07T14:38:27.3266667+00:00 Adjusting the network timeout on the SMSS configuration does not impact the issue in any way other than making it take a longer period of time to return the same error. Windows Firewall is disabled on the machine and there is no firewall between the Win11 box that I am attempting to launch SMSS from and the SQL server.
Sign in to comment -