System.Data.SqlClient.SqlException: 在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: SQL Network Interfaces, error: 26 - 定位指定的服务器/实例时出错)
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
http://stackoverflow.com/questions/1391503/a-network-related-or-instance-specific-error-occurred-while-establishing-a-conne
可能是端口问题,需要打开TCP 1433 / UDP 1434端口
http://www.cnblogs.com/humin/archive/2011/10/27/2227136.html
I've resolved the issue. It was due to the SQL browser service.
Solution to such problem is one among below -
Check the spelling of the SQL Server instance name that is specified in the connection string.
Use the SQL Server Surface Area Configuration tool to enable SQL Server to accept remote connections over the TCP or named pipes protocols. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.
Make sure that you have configured the firewall on the server instance of SQL Server to open ports for SQL Server and the SQL Server Browser port (UDP 1434).
Make sure that the SQL Server Browser service is started on the server.
最新文章
- session的常用方法。
- attrs 中的 uid
- add user
- 如何判断一个Div是否可视区域,判断div是否可见
- Python常用网页字符串处理技巧
- [MySQL复制异常]'Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.'
- win7 安装Oracle 10G,11G
- jQuery插入节点的方法
- 空指针错误 java.lang.NullPointerException
- JavaScript对象原型写法区别
- lxml etree的一个问题
- git 学习笔记(常用命令)
- Swift对象实例方法名混淆的解决
- JSTL varStatus属性
- 在IE中下载Office2007文件时在对话框中下载文件变成ZIP文件的问题
- Javascript URI 解析介绍
- linux文件打包并发送到其他服务器
- NIO完成网络通信(一)
- Class file collision
- (转)Cognos的下载地址分享