日期:2014-05-17  浏览次数:20633 次

2008登陆MangerStudio发生的错误
TITLE: Connect to Server
------------------------------

Cannot connect to PC2012071803VAV.

------------------------------
ADDITIONAL 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 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


------解决方案--------------------
http://www.cnblogs.com/zlhxinxi83/archive/2007/12/11/990622.html
http://blog.csdn.net/commandos/article/details/2237204
------解决方案--------------------
1.检查是否允许TCP/IP或Pipes进行远程连接
(开始->SQL SERVER 2005-配置工具->SQL Server 外围应用配置器->remote connection)
2.防火墙设置