SQL Server远程连接 provider: Named Pipes Provider, error: 40 消除办法

亚洲必赢app,置SQLServer,允许远程连接

依据地点的小说一步步配备后,远程连接出现上面所示的报错(Navicat 和 SQL
Server Management Studio)

亚洲必赢app 1

亚洲必赢app 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端口。若为新创设的安全组,还需重启服务器才可生效。

亚洲必赢app 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地图