我刚在家庭服务器上安装了SQL Server Express 2012。我试图从桌面PC上的Visual Studio 2012连接它,但一直收到如下常见错误信息:
"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)"
我已经采取以下措施来尝试解决此问题: - 在服务器上运行SQL Server Configuration Manager并启用SQL Server Browser。 - 在本地子网上为TCP的1433和1434端口添加了Windows防火墙例外。 - 验证我在桌面上所登录的用户在SQL Server实例上有一个登录账号。 - 确认我在使用SQL Server实例上的Windows身份验证。 - 反复重启SQL Server和整个服务器。 - 拔光头发。
我该怎么做才能让SQL Server 2012 Express允许远程连接呢?
"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)"
我已经采取以下措施来尝试解决此问题: - 在服务器上运行SQL Server Configuration Manager并启用SQL Server Browser。 - 在本地子网上为TCP的1433和1434端口添加了Windows防火墙例外。 - 验证我在桌面上所登录的用户在SQL Server实例上有一个登录账号。 - 确认我在使用SQL Server实例上的Windows身份验证。 - 反复重启SQL Server和整个服务器。 - 拔光头发。
我该怎么做才能让SQL Server 2012 Express允许远程连接呢?