在SQL Server 2008上工作时遇到错误 [英] Experiencing error while working on SQL Server 2008

问题描述

在使用SQL Server Management Studio 2008时，当我尝试访问服务器时，出现以下错误:

找不到服务器或无法访问服务器.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:命名管道提供程序，错误:40 –无法打开与SQL Server的连接)(Microsoft SQL Server，错误:2)

请给我建议一个永久且稳定的解决方案.

提前谢谢.

Indrajeet Bhattacharya

While working on SQL server management studio 2008, when I am trying to access the server I am getting the following error:

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: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Please suggest me a permanent and stable solution.

Thanks in advance.

Indrajeet Bhattacharya

推荐答案

可能是表面积配置错误或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 Server 2008上工作时遇到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！