SQL Server连接失败 [英] SQL Server Connection Failure

问题描述

建立与服务器的连接时发生错误.连接到SQL Server 2005时，此故障可能是由于以下事实导致的:在默认设置下，SQL Server不允许远程连接. (提供者:命名管道提供者，错误:40-无法打开与SQL Server的连接)


--------------------
我的局域网设置是通过路由器连接到我的两台计算机和一台打印机.我还格式化了我的主计算机，并将其中的SQL Server 2005清理干净.今天，偶然地，我坐在办公室里试图连接位于服务器办公系统中的SQL Server，突然我偶然发现了以下错误.

-------------------
我的服务器系统正常工作，但是我的本地系统不工作..我尝试了
我的本地系统开始菜单>运行> cmd> < b> ping -a [服务器名]</b>执行此命令但引发错误---< b> Ping请求找不到主机服务器，请检查名称并尝试再次进行</b>

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)


--------------------
I have LAN setup with router connected with my two computers,one printer .I had also formatted my primary computer and clean installed SQL Server 2005 into it. Today, incidentally, I was sitting in my office trying to connect SQL Server located in server office system and suddenly I stumbled upon the following error.

-------------------
my server system work correctly but my local system not working..i tried
my local system start menu > run > cmd > <b>ping -a [servername]</b> execute this command but throw error --- <b>Ping request could not find host server please check the name and try angain</b>

推荐答案

是外围应用配置错误或sql服务配置问题.请查看此线程的潜在原因和解决方法: [参见设置外围应用配置的步骤. .

如果这不能解决您的问题，请查看此线程:
http://forums.asp.net/t/1334649.aspx [

It might be surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving "A network-related or instance-specific error occurred while establishing a connection to SQL Server…" [^]

If needed, See steps for setting up Surface area configuration here..

If this does not resolve your issue, have a look at this thread:
http://forums.asp.net/t/1334649.aspx[^]
Quite few possible reasons and resolutions are proposed here too.

请确保使用LAN/互联网连接两台计算机.
[要检查连接性，请在DOS中使用PING命令.]

如果您确定两者都已连接，但仍然出现错误，请确保SQL Server服务正在服务器计算机中运行.
[转到服务(Windows开始->运行->类型Services.msc->出现服务列表->查找名为"SQL Server"和"SQL Server Agent"的服务->如果这些服务停止然后启动这些服务.]


如果您仍然遇到问题，请告诉我们.

希望对您有帮助

Hi,

Please make sure that two computer are connected using LAN/internet.
[ To check the connectivity use PING command in DOS.]

If you are sure that both are connected, and still you get the error make sure that SQL Server services are running in Server computer.
[ Go to services (windows start->run->type Services.msc-->list of Services appears --> find services named "SQL Server" and "SQL Server Agent"--> if these services are stopped then start these services. ]


If you still get the problem let us know.

Hope it helps you,

这篇关于SQL Server连接失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！