问题描述
大家好，
首先，我在PC上安装了vs 2010，然后安装了sql server2005.
现在，如果我尝试通过Management Studio连接sql server2005，则会引发类似-
的错误
" sql服务器不允许远程连接，SQL网络接口，错误:26-指定服务器/实例时出错定位与服务器建立连接时发生错误.连接到SQL Server 2005时，此故障可能是由于在默认设置下，SQL Server不允许远程连接的事实.(提供者:命名管道提供程序，错误:40-无法打开与SQL Server的连接)"
请帮我解决问题.
在此先感谢.
Rajiv Kumar
Hello All,
First I have installed vs 2010 in my pc and then I have installed sql server 2005.
Now if I tried to connect sql server2005 through management studio it throw error like-
"sql server does not allow remote connections,SQL Network Interfaces, error: 26 - Error Locating Server/Instance SpecifiedAn error has occured 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 connection to SQL Server))"
Please help me how to resolve it.
Thank in Advance.
Rajiv Kumar
推荐答案
这篇关于关于连接SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！