无法建立与 SQL Server 的连接
我正在尝试从位于服务器（具有 IIS7）上的应用程序访问位于我的计算机上的 SQL DB。
我在 WebConfig 中使用计算机的 IP 设置 ConnectionString，但总是收到此错误：
发生网络相关或特定于实例的错误 建立与 SQL Server 的连接。找不到服务器或 无法访问。验证实例名称是否正确 SQL Server 配置为允许远程连接。 （提供者：命名 Pipes Provider，错误：40 - 无法打开与 SQL Server 的连接）
我想启用远程连接，正如错误中提到的那样。为了使它工作，我尝试了以下方法：
- 确保在我的服务器的属性窗口中选中“允许远程连接”到该服务器
- 在 SQL Server 配置管理器中启用 TCP/IP
- 右键单击 TCP/ IP 并在“属性”中将端口设置为 1433 并删除动态端口中的“0”
- 在 Windows 防火墙中创建新规则以允许来自端口 1433 的连接
- 将 MSSQL/Binn 文件夹中的 sqlservr.exe 添加到“允许程序通过 Windows 防火墙”
- 重新启动服务
没有任何帮助。我还能做什么？
编辑：
连接字符串：
<connectionStrings>
<add name="someName" connectionString="Database=someDB;Server=<my computer's IP>;User=userName;Password=123" providerName="System.Data.SqlClient"/>
</connectionStrings>
I am trying to access SQL DB that is located on my computer from an application that is located on a server (has IIS7).
I set the ConnectionString in the WebConfig with the IP of my computer and I always get this error:
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)
I wanted to enable remote connections as it was mentioned in the error. These are the things that I tried in order to make it work:
- Made sure that "Allow remote connections" to this server is checked in the properties window of my server
- Enabled TCP/IP in the SQL Server Configuration Manager
- Right clicking on the TCP/IP and in "Properties" set the port to 1433 and removed the "0" in the Dynamic Ports
- Created a new rule in the Windows Firewall to allow the connection from port 1433
- Added sqlservr.exe from the MSSQL/Binn folder to "Allow a program through Windows Firewall"
- Restarted the service
None of it helped. What else can I do?
EDIT:
Connection string:
<connectionStrings>
<add name="someName" connectionString="Database=someDB;Server=<my computer's IP>;User=userName;Password=123" providerName="System.Data.SqlClient"/>
</connectionStrings>
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我正在展示 SQL Express 设置，这在标准版本和其他版本中应该是相同的。
检查此项并按照第一个链接了解连接规范和测试此问题。
检查这些链接以检查是否存在与此特定主题相关的错误并修复此问题：
解决“网络相关或特定于实例的错误”
SQLAuthority- 无法打开连接
I am showing SQL Express setting this should be same in standard and other versions.
check this and follow the first link for connection specification and testing for this problem.
Check these links for checking error exists regarding this particular topic and fixing this:
Resolving “A network-related or instance-specific error"
SQLAuthority- could not open connection