无法连接到SQL Express，“错误:26错误，指定了服务器/实例的位置) [英] Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

问题描述

我对一个运行SQL Server 2008 R2 Express的特定机器一无所获.

I am at an loose end with one particular box that is running SQL Server 2008 R2 Express.

• Windows防火墙配置为允许入站TCP& UDP 1433，1434.
• Windows防火墙配置为允许出站TCP& UDP在任何端口上.
• 当前没有其他软件正在运行.

当我尝试连接到xxx.xxx.xxx.xxx\sqlexpress时，它超时并显示以下错误:

When I try to connect to xxx.xxx.xxx.xxx\sqlexpress, it times out with the following error:

标题:连接到服务器

TITLE: Connect to Server

无法连接到xxx.xxx.xxx.xxx \ SQLEXPRESS.

Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS.

其他信息:

建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:SQL网络接口，错误:26-错误指定服务器/实例的位置)(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: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

我检查了服务器上是否允许远程连接.

I have checked that remote connections are allowed on the server.

我已确认在SQL Server配置中启用并配置了TCP/IP，以允许外部IP上的连接到1433.

I have confirmed TCP/IP is enabled and configured in SQL Server Configuration to allow connections on the external IP to 1433.

我还从本地计算机上使用了Wireshark，可以看到对1433 UDP的请求发送到远程服务器.

I have also used Wireshark from my local machine and I can see requests for 1433 UDP going to the remote server.

但是在远程服务器上使用Wireshark时，没有显示对1433 UDP或任何来自我的外部IP的入站连接请求(具有从结果过滤到远程RDP的信息).

But using Wireshark on the remote server shows no inbound connection requests for 1433 UDP or anything from my external IP (with filtering to remote RDP from results).

这使我认为这是防火墙问题.

This makes me think it is a firewall issue.

该服务器由外部公司托管，该公司对我们服务器前的PIX拥有控制权.

The server is hosted by an external company who have control over the PIX in front of our server.

我需要尽可能自己解决此问题，因为托管公司不知道他们在做什么.

I need to troubleshoot this as much as possible myself as the hosting company have no clue what they are doing.

推荐答案

我遇到了类似的问题，该问题已通过转到"SQL Server配置管理器"并确保将"SQL Server浏览器"配置为自动启动来解决.并开始了.

I had a similar problem which was solved by going to the "SQL Server Configuration Manager" and making sure that the "SQL Server Browser" was configured to start automatically and was started.

我在此论坛帖子的答案中遇到了这种解决方案: http://social.msdn.microsoft.com/Forums/zh-CN/sqlexpress/thread/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4/

I came across this solution in the answer of this forum post: http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4/

我希望这对外面的人有帮助.

I hope this helps somebody out there.

这篇关于无法连接到SQL Express，“错误:26错误，指定了服务器/实例的位置)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！