I installed SQL Server 2008 on my machine which is (Windows XP SP3).
我在我的机器上安装了SQL Server 2008 (Windows XP SP3)。
Also I have Visual Studio 2008 installed in another machine on which there is a .net application. Now while I am trying to connect to the SQL Server from my .NET application.
我还在另一台机器上安装了Visual Studio 2008，上面有一个。net应用程序。现在，当我尝试从我的。net应用程序连接到SQL服务器时。
I am unable to do so. I get an error message :
我不能这样做。我收到一条错误信息:
The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following: the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)
由于在登录之前连接初始化过程中出现错误，客户端无法建立连接。可能的原因包括:客户机试图连接到不支持的SQL Server版本;服务器忙得无法接受新的连接;或者服务器上存在资源限制(内存不足或允许的最大连接)。(提供程序:命名管道提供程序，错误:0 -管道的另一端没有进程。)
Is it because of the client version being 2005 (which gets installed by default with Visual Studio 2008) and SQL Server being 2008?
是因为客户端版本是2005(默认安装为Visual Studio 2008)还是SQL Server是2008?
1 个解决方案
#1
6
provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.
提供者:命名管道提供程序，错误:0 -没有进程在管道的另一端。
Do you actually have named pipes enabled for your SQL Server?
您是否已经为SQL服务器启用了命名管道?
#1
6
provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.
提供者:命名管道提供程序，错误:0 -没有进程在管道的另一端。
Do you actually have named pipes enabled for your SQL Server?
您是否已经为SQL服务器启用了命名管道?