与SqlServer 2005连接时出错 [英] Error while connecting with SqlServer 2005
问题描述
亲爱的朋友,
我正在Asp.net C#上工作,而DB是SqlServer2005.
我已经做了一个Intranet应用程序...并且我的数据库在Server中.我需要通过服务器连接它.
在SqlServer 2005中使用Windows身份验证
因此,当我运行该应用程序时...将显示登录页面.当我输入用户名,密码并单击登录时,它显示错误....
这是正在得到的错误.
================================================== =======================
由于登录之前的连接初始化过程中发生错误,客户端无法建立连接.可能的原因如下:客户端尝试连接到不受支持的SQL Server版本;服务器太忙,无法接受新连接;或服务器上存在资源限制(内存不足或允许的最大连接数). (提供者:命名为管道提供者,错误:0-管道的另一端没有进程.)
================================================== =======================
请任何人都可以帮助我该怎么做.
Dear Friends,
Am working on Asp.net C# , and DB is SqlServer 2005.
I have made a Intranet Application...and my database is in Server. I need to connect it through server.
am using Windows Authentication in SqlServer 2005
So, when i run the application...its displays login page. when i enter username , password and clicks on login it shows an error....
This is the error what am getting.
==========================================================================
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.)
==========================================================================
Please anybody can help me how to do this.
Thanks.
推荐答案
此错误的常见原因可能是未启用命名管道.
请参考以下链接进行故障排除:
解决管道另一端没有进程" SQL Server中的错误 [ MSDN:故障排除:管道的另一端没有进程 [ ^ ]
MSDN博客:证书错误导致管道的另一端没有进程" [ ^ ]
A common reason for this error is possibly that named pipes are not enabled.
Refer following links to troubleshoot:
Resolving "No Process is on the Other End of the Pipe" Error in SQL Server[^]
MSDN: Troubleshooting: No Process Is on the Other End of the Pipe[^]
MSDN Blog: "No process is on the other end of pipe" caused by bad certificate[^]
请使用sql身份验证模式登录.
请尝试一下以获得更好的结果.
pls login using sql authentication mode.
Kindly try this for better results.
请参阅以下帖子
sql服务器登录问题 [
Refer to the following post
sql server login problem[^]
best of luck.........
这篇关于与SqlServer 2005连接时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!