SQL Server Express服務啟動失敗，關閉VIA協議就好了

昨天對Sql server 2005進行設定後,服務就啟動不了了,後來查看日誌,有這樣一段話:

 

2008-09-05 08:40:17.82 伺服器         A self-generated certificate was successfully loaded for encryption.
2008-09-05 08:40:17.82 伺服器         錯誤: 17182，嚴重性: 16，狀態: 1。
2008-09-05 08:40:17.82 伺服器         TDSSNIClient initialization failed with error 0x7e, status code 0x60.
2008-09-05 08:40:17.82 伺服器         錯誤: 17182，嚴重性: 16，狀態: 1。
2008-09-05 08:40:17.82 伺服器         TDSSNIClient initialization failed with error 0x7e, status code 0x1.
2008-09-05 08:40:17.82 伺服器         錯誤: 17826，嚴重性: 18，狀態: 3。
2008-09-05 08:40:17.82 伺服器         Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2008-09-05 08:40:17.82 伺服器         錯誤: 17120，嚴重性: 16，狀態: 1。
2008-09-05 08:40:17.82 伺服器         SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

 

 

然後就在網上查相關資料,終於發現原來我把“VIA協議”給啟用了，停用“VIA協議”問題解決。

 

"VIA協議"停用方法：開始->程式->Microsoft SQL Server 2005->組態工具->SQL Server Configuration Manager ->開啟後找到"SQL Server 2005 網路設定"->MSSQLSERVER 屬性的協議   在右邊的屬性框中把“VIA協議”禁用即可!

 

希望能夠給遇到相同問題的朋友提供一點協助!