我无法访问SQL 2005实例的所有原因 [英] All the reasons I can't access an instance of SQL 2005

问题描述

我在<计算机名> / SQLEXPRESS 上安装了SQL 2005 Express实例。仅安装一次实例。我已经允许远程连接，启用SQL身份验证，启用了TCP / IP，命名管道和VIA，但仍然无法从另一台计算机访问该数据库。我不断得到：

I've installed an instance of SQL 2005 Express on <computername>/SQLEXPRESS. There is only once instance installed. I've allowed remote connections, turned on SQL authentication, enabled TCP/IP, Named Pipes and VIA but I still can't access the database from another computer. I keep getting:

与SQL建立
连接时发生与网络相关或特定于实例的
错误服务器。找不到服务器
或无法访问该服务器。
验证实例名称是否正确，并且SQL Server已配置为允许远程
连接的
。 （提供者：SQL Network
接口，错误：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)

什么我还能找吗？我确定我的代码是正确的，因为它是在擦除之前用于连接到同一系统的。我非常有信心连接字符串也是正确的：

What else can I look for? I'm sure my code is correct as it was used to connect to this same system prior to it being wiped. I'm pretty confident the connection string is correct as well:

Server=<computername>\SQLEXPRESS;User Id=<username>;Password=<password>;

两个系统之间也没有防火墙。它们在同一网段上，并且Windows防火墙已完全关闭。

There's also no firewalls standing between the two systems. They're on the same network segment and Windows Firewall has been shut off completely.

推荐答案

SQL Server Browser是否正在运行机？对于命名实例，例如\SQLExpress，SQL Browser允许客户端计算机标识要连接到的端口。

Is the SQL Server Browser running on the machine? For named instances, like \SQLExpress, the SQL Browser allows client machines to identify which port to connect to.

默认情况下，只有默认实例在TCP 1433上运行。如果客户端无法在默认端口上连接，它将查询UDP 1434上的SQL Browser以找到给定命名实例使用的正确端口。

By default, only the default instance runs on TCP 1433. If the client can't connect on the default port, it queries the SQL Browser at UDP 1434 to locate the correct port to use for a given named instance.

这篇关于我无法访问SQL 2005实例的所有原因的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！