菜单

SQL Server远程连接 provider: Named Pipes Provider, error: 40 解决模式

2019年1月14日 - MySQL

置SQLServer,允许远程连接

遵照下边的著作一步步部署后,远程连接出现上边所示的报错(Navicat 和 SQL
Server Management Studio)

manbetx网页手机登录版 1

manbetx网页手机登录版 2

SQL Server Management Studio的报错音信为:

manbetx网页手机登录版,在与 SQL Server
建立连接时出现与网络有关的或特定于实例的谬误。未找到或不能访问服务器。请表明实例名称是否科学并且
SQL Server 已布置为允许远程连接。 (provider: Named Pipes Provider,
error: 40 – 不能开拓到 SQL Server 的连接) (Microsoft SQL Server,错误:
53)。

新兴查了累累缓解办法,均以败诉告终。后来无意发现到,远程数据库所在云服务器的安全组未开放对该端口的远程访问权限,以自身所用的阿里云为例,在安全组->配置规则->迅速创制规则
中,添加MS SQL的1433端口。若为新创造的安全组,还需重启服务器才可生效。

manbetx网页手机登录版 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地图