SQL Server远程连接 provider: Named Pipes Provider, error: 40 化解格局

发布时间:2019-07-20  栏目:sqlite  评论:0 Comments

置SQLServer,允许远程连接

依照上面的稿子一步步布署后,远程连接出现上边所示的报错(Navicat 和 SQL
Server Management Studio)

图片 1

图片 2

SQL Server Management Studio的报错音信为:

在与 SQL Server
建设构造连接时出现与互联网有关的或特定于实例的一无所能。未找到或很小概访谈服务器。请证实实例名称是不是准确况且SQL Server 已布局为允许远程连接。 (provider: Named Pipes Provider,
error: 40 – 不或许打开到 SQL Server 的连日) (Microsoft SQL Server,错误:
53)。

后来查了非常多减轻方法,均以退步告终。后来懒得开采到,远程数据库所在云服务器的安全组未开放对该端口的长距离访问权限,以自身所用的Ali云为例,在安全组->配置准则->飞快创制法则
中,增添MS SQL的1433端口。若为新制造的安全组,还需重启服务器才可生效。

图片 3

 

 

Server Error in ‘/’ Application.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

Description: An unhandled
exception occurred during the execution of the current web request.
Please review the stack trace for more information about the error and
where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: A network-related or
instance-specific error occurred while establishing a connection to SQL
Server. The server was not found or was not accessible. Verify that the
instance name is correct and that SQL Server is configured to allow
remote connections. (provider: Named Pipes Provider, error: 40 – Could
not open a connection to SQL Server)

消除措施:

摄像文书档案:.wmv;大小:8,840KB;长度:00:05:19

下载地址: http://download.cnblogs.com/insus/SQL/Could%20not%20open%20a%20connection%20to%20SQL%20Server.zip

留下评论

网站地图xml地图