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

Question

question

ShivaPrasadreddy-5827 asked · Feb 19 at 11:26 AM

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-general dotnet-sqlclient

· 1

10 |1000 characters needed characters left characters exceeded

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

Cathyji-msft · 6 days ago

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 ·

Answer 1 · 2021-02-19T12:26:13.917Z

OlafHelper-2800 answered · Feb 19 at 12:26 PM

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

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

Answer 2 · 2021-02-19T22:37:30.827Z

ErlandSommarskog answered · Feb 19 at 10:37 PM

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

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

Answer 3 · 2021-02-22T06:18:20.103Z

Cathyji-msft answered · Feb 22 at 06:18 AM

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

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

question