Azure SQL Database
An Azure relational database service.
5,787 questions
Have you set connection encyption; for Azure SQL Databases it's mandatory?
Microsoft SQL Server, Error: 10054
![](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(284.8, 69%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
LA METISSE
0
Reputation points
I have a problem with Microsoft SQL Server Management Studio when I'm at home with a internet that does not have IP address as usually when I'm not in my condo unit and almost sometimes impossible to connect or even list the tables.. but if i use SQL query is working OK.. Please what i have to do ??
============
Wireless LAN adapter Wi-Fi:
Connection-specific DNS Suffix . :
IPv6 Address. . . . . . . . . . . : 2001:4454:714:d800:ca0:a3e5:20c4:3a47
Temporary IPv6 Address. . . . . . : 2001:4454:714:d800:906e:6fb5:b6b8:1bb7
Temporary IPv6 Address. . . . . . : 2001:4454:714:d800:a0a5:f930:43b6:22c
Temporary IPv6 Address. . . . . . : 2001:4454:714:d800:cd86:8946:772e:8d4b
Link-local IPv6 Address . . . . . : fe80::f8d0:2d19:3307:145c%14
IPv4 Address. . . . . . . . . . . : 192.168.1.8
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : fa80::1000%12
192.168.1.1
[note: I have changed some letters to avoid disclosing real values]
==========
...
TITLE: Microsoft SQL Server Management Studio
Failed to connect to server appsalon.database.windows.net. (Microsoft.SqlServer.ConnectionInfo)
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10054-database-engine-error
An existing connection was forcibly closed by the remote host
BUTTONS:
OK
{count} votes
-
![](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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA 3,425 Reputation points Microsoft Vendor2024-10-04T17:27:18.16+00:00 @LA METISSE
Just checking in to see if the below answer helped. If this answers your query, do clickAccept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know.
Sign in to comment
3 answers
Sort by: Most helpful
-
-
Alberto Morillo 34,056 Reputation points MVP2024-10-03T03:41:20.8333333+00:00 When you face that error 10054 and pre-login handshake errors that means you are facing network latency issues or delays in certificate validation by the SqlClient driver. Pre-login handshake should ideally complete in 100-200 ms but it could be taking way longer maybe due to proxy configuration or other reasons. You can verify that using a network trace.
-
ZoeHui-MSFT 37,976 Reputation points2024-10-07T02:12:17.0533333+00:00 Hi @LA METISSE,
You may refer to below documentation.
An existing connection was forcibly closed by the remote host (OS error 10054)
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
-
NIKHILA NETHIKUNTA 3,425 Reputation points Microsoft Vendor
2024-10-07T04:28:39.3533333+00:00 @LA METISSE
Following up to see if the above answer was helpful. If this answers your query, do clickAccept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know.
Sign in to comment -