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

Shiva Prasad reddy 1 Reputation point
2021-02-19T11:26:04.903+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,488 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 40,246 Reputation points
    2021-02-19T12:26:13.917+00:00

    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

    0 comments No comments

  2. Erland Sommarskog 100.1K Reputation points MVP
    2021-02-19T22:37:30.827+00:00

    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?

    0 comments No comments

  3. CathyJi-MSFT 21,066 Reputation points Microsoft Vendor
    2021-02-22T06:18:20.103+00:00

    Hi @Shiva Prasad reddy ,

    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.

    0 comments No comments