SQL Server Express无法连接错误:28-服务器不支持请求的协议 [英] SQL Server Express cannot connect error: 28 - Server doesn't support requested protocol

问题描述

我无法从服务器(Windows 2008 R2)连接到本地SQL Server Express(2012，但版本无关紧要)，以在其上使用工具(如果您想知道，请使用APEX SQL Data Diff).我可以很好地浏览网络服务器，然后从可用服务器的下拉列表中选择本地实例，但是当我在服务器上搜索表时，它会因该错误消息而超时(SSMS也是一样).

I cannot connect to my local SQL Server Express (2012, but the version shouldn't matter) from my server (Windows 2008 R2) to use a tool on it (APEX SQL Data Diff if you are wondering). I can browse the network servers fine, and select my local instance from the dropdown of available servers, but when I go to search tables on the server, it times out with this error message (same is true of SSMS).

建立与SQL Server的连接时发生与网络相关或特定于实例的错误.找不到服务器或 无法访问.验证实例名称正确，并且 SQL Server配置为允许远程连接. (提供者:SQL 网络接口，错误:28-服务器不支持强文本 请求的协议)(Microsoft SQL Server，错误:-1)

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: 28 - Server doesn't support strong text requested protocol) (Microsoft SQL Server, Error: -1)

我启用了防火墙-不是.

I have enabled the firewall - that's not it.

我允许远程连接-不是.

I have allowed remote connections - that's not it.

SQL Server Browser服务已打开并通过防火墙-不是.

SQL Server Browser service is on and passed through the firewall - that's not it.

我可以使用相同的工具 TO 服务器正常连接，但是 FROM 服务器失败.

I can connect fine with the same tools TO the server, but FROM the server it fails.

有什么想法吗?

推荐答案

感谢

Thanks to this article for getting me somewhere with the error message. The issue is the necessary network protocols are disabled by default in SQL Server Express. I had to go to Sql Server Configuration Manager locally and turn on "Named Pipes" and "TCP/IP". After that, you need to restart the SQL Server Browser and SQL Server(instance) services.

虽然不是必须的，但您可能还需要在协议"下的"SQL Server网络配置"中检入需要在此处进行调整的设置.

While I did not have to, you may also need to check in "SQL Server Network Configuration" under "Protocols" for settings that need adjusted there.

希望这对其他人有帮助！

Hope this helps someone else!

这篇关于SQL Server Express无法连接错误:28-服务器不支持请求的协议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！