这是命名实例吗？如果是这样，您需要确保端口 1434（SQL Server Browser 的默认端口）已打开并正在侦听。
此外，如果它是命名实例，您需要确保已启动 SQL Server Browser 服务。您可以通过 SQL Server 配置管理器来执行此操作。
Is this a named instance? If so, you need to ensure port 1434 (the default port for SQL Server Browser) is open and listening.
Also, if it is a named instance, you need to ensure that you have the SQL Server Browser service started. You can do this through the SQL Server Configuration Manager.
我发现 Windows 7 防火墙 UI 与 XP 相比相当混乱，有时我更幸运的是完全关闭它并尝试连接以检查问题是否出在哪里。
事实上，尝试在 pc1 和 pc2 机器上将其关闭。
Have you tried turning off windows firewall in your server box altogether?
I find windows 7 firewall UI pretty confusing compared to XP, sometimes I have more luck just turning it off altogether and attempting a connection to check if that is where the problem is.
In fact, try turning it off on both pc1 and pc2 machines.
发布评论
评论（3）
这是命名实例吗？如果是这样，您需要确保端口 1434（SQL Server Browser 的默认端口）已打开并正在侦听。
此外，如果它是命名实例，您需要确保已启动 SQL Server Browser 服务。您可以通过 SQL Server 配置管理器来执行此操作。
Is this a named instance? If so, you need to ensure port 1434 (the default port for SQL Server Browser) is open and listening.
Also, if it is a named instance, you need to ensure that you have the SQL Server Browser service started. You can do this through the SQL Server Configuration Manager.
您是否尝试过完全关闭服务器中的 Windows 防火墙？
我发现 Windows 7 防火墙 UI 与 XP 相比相当混乱，有时我更幸运的是完全关闭它并尝试连接以检查问题是否出在哪里。
事实上，尝试在 pc1 和 pc2 机器上将其关闭。
Have you tried turning off windows firewall in your server box altogether?
I find windows 7 firewall UI pretty confusing compared to XP, sometimes I have more luck just turning it off altogether and attempting a connection to check if that is where the problem is.
In fact, try turning it off on both pc1 and pc2 machines.
好吧，不知何故，在我的问题中的所有项目符号列表
在sql管理工作室中
服务器名称：（pc2的IP地址）有效，不需要括号
OR
服务器名称：（pc2 的计算机名称）有效，无需括号
这两个都不起作用
其他答案
我的 pc2 是否需要仅以管理员身份登录才能连接 pc1？
否
或者非管理员用户可以在 pc2 上工作而我仍然可以使用 pc1 进行连接吗？ 是
只要 SQL SERVER 服务已打开，就可以在没有任何人登录的情况下简单地打开 pc2
well somehow following thing worked without making any other changes after all bulleted list in my question is true
in sql management studio use
server name: (IP address of pc2) works , no need to have parenthesis
OR
server name: (COMPUTERNAME of pc2) works , no need to have parenthesis
BOTH OF THESE DO NOT WORK
other answers
Does my pc2 needs to be logged in as administrator only in order for pc1 to connect?
NO
Or Can a non admin user work on pc2 and I can still connect using pc1? YES
pc2 can be be simply turned on without anybody logged in provided the SQL SERVER service is turned on