provider：SSL Provider，错误：0 - 远程主机强行关闭现有连接。 [英] provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.

问题描述

服务器：SQL Server 2016 13.0.5026.0

客户端：

1。 SSMS 12.0.2000.8

错误： 

与服务器成功建立连接，但是在登录过程中发生了错误。 （提供程序：SSL提供程序，错误：0 - 远程主机强制关闭现有连接。）（Microsoft SQL Server，错误：10054）

2。 SQLCMD

C：\Program Files\Microsoft SQL Server \Client SDK \ODBC \110\Tools \Binn>。\sqqlcmd -E -S server \\ \\ instance

错误：

Sqlcmd：错误：用于SQL Server的Microsoft ODBC驱动程序11：SSL提供程序：远程主机强制关闭现有连接。 br $>
。
$
Sqlcmd：错误：SQL Server的Microsoft ODBC驱动程序11：客户端无法建立连接。

---

SkyRiver

解决方案

您好，

1）您是否尝试在本地或从远程服务器使用数据库服务器中的ssms和sqlcmd连接SQL实例？ / p>

2）数据库服务器上是否正在运行浏览器服务。

3）为数据库服务器中的远程连接打开防火墙。

4）这是新安装还是最近出现了这个问题？

问候;

Vivek Janakiraman

www.jbswiki.com

server: SQL Server 2016 13.0.5026.0

client:

1. SSMS 12.0.2000.8

error: 

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)

2. SQLCMD

C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn>.\sqlcmd -E -S server\instance

Error:

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SSL Provider: An existing connection was forcibly closed by the remote host.
.
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Client unable to establish connection.

---

SkyRiver

解决方案

Hello,

1) Are you trying to connect the SQL instance using ssms and sqlcmd from your database server locally or from a remote server?

2) Is browser service running on your DB server.

3) is firewall opened for the remote connection in your database server.

4) Is this a new installation or this issue has cropped up recently?

Regards;
Vivek Janakiraman
www.jbswiki.com

这篇关于provider：SSL Provider，错误：0 - 远程主机强行关闭现有连接。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！