sql server登录错误 [英] sql server login errors
问题描述
我们正在使用sqlserver 2008，并且操作系统是Windows XP.
当我将站点数据库与SQL Server Management 2008连接时，出现以下错误:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)
两个月前我没有遇到这个问题.昨天开始，此错误开始(连接有时会断开，但以后会连接).我在许多站点上搜索了该问题，但找不到正确的解决方案.
服务器名称:192.168.1.4
错误编号:64
严重程度:20
状态:0
请帮助我解决此错误.
We are using sqlserver 2008 and operating system is Windows XP.
When I connect my site database with SQL Server Management 2008 I see following error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)
I didn''t had this problem before 2 months. Yesterday onnwards this error started (the connection sometimes disconnected but later connected). I searched many sites for the problem but I couldn''t find a correct solution.
Server Name: 192.168.1.4
Error Number: 64
Severity: 20
State: 0
Please help me solve this error.
推荐答案
检查此链接是否存在您的问题:
http://blogs.advantaje.com/blog/kevin/Net/?permalink= SQLExpress-Problems.html [ ^ ]
Tej Aj，
http://opexsolution.com/forum/
粉丝:
http://www.abtstudioz.com/
check this link for ur problem:
http://blogs.advantaje.com/blog/kevin/Net/?permalink=SQLExpress-Problems.html[^]
Tej Aj,
http://opexsolution.com/forum/
Fan Of:
http://www.abtstudioz.com/
您的连接已断开，这是问题，我的意思是您的数据库服务器计算机已关闭或SQL Server服务已停止，或进行某些检查，因此请对其进行检查.还要在您的数据库服务器中检查事件查看器.
Your connection was broken that''s the problem i mean your Database server machine is OFF or SQL server service was stopped or something so check it. Check the event viewer in your Database server too.
我前一段时间有这个问题.原来是干扰登录的McAfee Host Intrusion Protection System(HIPS).
请注意，可能还有更多可能的情况.
I had this problem once a while ago. Turned out to be a McAfee Host Intrusion Protection System (HIPS) interfering with the login.
Mind you, there may be more likely scenarios.
这篇关于sql server登录错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
