question

ShivaPrasadreddy-5827 avatar image
0 Votes"
ShivaPrasadreddy-5827 asked ·

Cannot connect to serevr Below SQL server 13.0 from ssms 18.8 in windows 10


TITLE: Connect to Server



Cannot connect to ....


ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider,
error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=10054&LinkId=20476



An existing connection was forcibly closed by the remote host


BUTTONS:

OK

sql-server-generaldotnet-sqlclient
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShivaPrasadreddy-5827,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let me know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered ·

Cannot connect to ....

You could, the connection was established, as the error already says.
But the SQL Server closed the connection by security/TLS related reason.
See Applications experience forcibly closed TLS connection errors when connecting SQL Servers in Windows for more details


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ·

Assuming that Olaf's theory is correct, it may be that you have not applied any service pack to your SQL instance. Go to C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSQLSERVER\MSSQL\LOG and look at the first line in the file ERRORLOG. On my instance it says:

Microsoft SQL Server 2016 (SP2-CU16) (KB5000645) - 13.0.5882.1

If it does not say SP2 in the parenthesis, you are behind and you should download and install the most recent service pack.

Note: the exact path depends on your installation.

By the way. there are many dots in the error message. What did you actually type?

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered ·

Hi @ShivaPrasadreddy-5827,

We can using SSMS 18.8 connect to any versions of SQL server.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider,
error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

You need to check your SSL and TLS settings.
Check out this KB 3135244. The settings between the client and server should be somewhat consistent (i.e. if the server only allows 1.2 and the client only supports 1.0 I think you might run into issues). Also read through the known issues on that page. Updating to a build that supports TLS 1.2 might resolve your issue.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.



· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.