title: SQL Server: connection was successfully established with the server, but then an error occurred during the pre-login handshake
body: <p>I have SQL Server 2019 and SSMS installed on my local system. I want to connect to remotely connect to another SQL Server with SSMS using these credentials:</p>
  <ul>
  <li>Server Name: 194.37.76.314,88756</li>
  <li>Authentication: SQL Server Authentication</li>
  <li>Login: myusername</li>
  <li>Server Name: mypassword</li>
  </ul>
  <p>I got this error:</p>
  <blockquote>
  <p>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.) (.Net SqlClient Data Provider)</p>
  <p>Server Name: 194.37.76.314,88756 Error Number: 10054<br />
  Severity: 20 State: 0</p>
  <p>Program Location:</p>
  <p>at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)<br />
  at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)<br />
  at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)<br />
  at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource<code>1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)     at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource</code>1 retry, DbConnectionOptions userOptions)<br />
  at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource<code>1 retry, DbConnectionOptions userOptions)     at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource</code>1
  retry)    at
  System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1
  retry)    at System.Data.SqlClient.SqlConnection.Open()    at
  Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo
  ci, IServerType server)    at
  Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()</p>
  <p>===================================</p>
  <p>An existing connection was forcibly closed by the remote host</p>
  </blockquote>
  <p>I have been connecting to the SQL Server before, but this error just started suddenly.</p>
  <p>I tried to implement:</p>
  <ul>
  <li><p>Used the SQL Server Configuration Manager tool to enable the TCP/IP and/or the Named Pipes protocols on the SQL Server client computer.</p>
  </li>
  <li><p>Click Start, point to All Programs, and click SQL Server Configuration Manager. Click to expand SQL Server Network Configuration and then click Client Protocols. Right-click the TCP/IP protocol and then click Enable. Right-click the Named Pipes protocol and then click Enable.</p>
  </li>
  <li><p>Restart the SQL Server service if prompted to do so.</p>
  </li>
  </ul>
  <p>from</p>
  <blockquote>
  <p><a href="https://stackoverflow.com/questions/3270199/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ">A connection was successfully established with the server, but then an error occurred during the pre-login handshake</a></p>
  </blockquote>
  <p>Yet unresolved.</p>
  <p>How do I resolve this?</p>
  <p>Thank</p>