无法突然连接正在运行的SQL Server [英] unable to connect a running sql server suddenly

问题描述

我无法连接到[服务器名]

信息:
建立与sql服务器的连接时发生与网络相关或特定于实例的错误.
找不到服务器或无法访问服务器.
验证实例名称正确并且已将sql服务器配置为允许远程连接(提供程序的名称为管道提供程序，错误40)


解决方案是什么?

Hi,

I cannot connect to [servername]

Information:
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 the instance nameis correct and that sql server is configured to allow remote connections (provider named pipes provider , error 40)


What''s the solution?

推荐答案

可能是表面积配置错误或sql服务配置问题.

请查看此线程的潜在原因和解决方法: ^ ]
如果需要，请在此处参见设置外围应用配置的步骤. .

如果这不能解决您的问题，请查看以下线程:
http://forums.asp.net/t/1334649.aspx [ SQL服务器修复错误(提供者:命名管道 [

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 these thread:
http://forums.asp.net/t/1334649.aspx[^]
SQL SERVER FIX ERROR (provider: Named Pipes [^]
Quite few possible reasons and resolutions are proposed here too.

在连接到sql时，这个问题会出现很多次.

That''s problem coming many times while connection to sql.

HERE[^] is a very good solution for concentrating for that problem only.

这篇关于无法突然连接正在运行的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！