sql server2005服务无法启动

最新推荐文章于 2022-05-17 21:50:25 发布

weixin_34075551

最新推荐文章于 2022-05-17 21:50:25 发布

阅读量341

点赞数

文章标签：数据库操作系统

本文介绍了解决SQL Server 2005无法正常启动的问题过程。主要故障表现为服务无法启动，错误信息提示连接失败及VIA协议初始化失败等。最终通过禁用VIA协议解决了该问题。

發現sql server2005無法正常啟動.
1.在SQL Server configuration Manager-->SQL Server 2005 Services-->SQL Server(INSTANCE2005)啟動不了.錯誤信息為:
The request failed or the service did not respond in a timely fashion,Consult the event log or other applicable error logs for details;
2.電腦中紀錄其中之一的錯誤日誌為:
SQL Server could not spawn FRunCM thread.Check the SQL Server error log and the Windows event logs for the information about possible related problesm.
3.打開Database Engine報錯如下:
An error has occurred 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 a connection to SQL Server) (Microsoft SQL Server, Error: 2)

还有这个错误:

the request failed or the service did not respond in timely fashion.consult the event log or other applicable error logs for details

检查结果：

系統電腦日誌第一個錯誤信息含有如下內容的:
the sql server failed to initialize VIA support

最后在sql服务里把VIA協議停掉就好了