This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
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
An Azure relational database service.
Additional SQL Server features and topics not covered by specific categories
![](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)
@LA METISSE
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
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.
@LA METISSE
Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
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.
Have you set connection encyption; for Azure SQL Databases it's mandatory?