关于连接SQL Server 2005 [英] Regarding connecting sql server 2005

问题描述

大家好，

首先，我在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不允许远程连接.您需要自己配置.此MSDN文章向您展示了如何
如何将SQL Server 2005配置为允许远程连接 [

By default SQL server does not allow remote connections. You need to configure it yourself. This MSDN article shows you how
How to configure SQL Server 2005 to allow remote connections[^]

Hope this helps

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