sql菜鸟问题:sqlserver2008无法正常启动,该怎么解决
之前sqlserver可以正常启动,但是所在服务器更换IP后,无法正常启动。
错误提示如下:请求失败或服务未及时响应。有关详细信息,请参见时间日志或其他适用的错误日志。
事件查看器显示的错误信息如下:
事件类型: 错误
事件来源: MSSQL$SQLEXPRESS
事件种类: Server
事件 ID: 26024
日期: 2016-6-18
事件: 19:53:33
用户: N/A
计算机: YL-201301252012
描述:
Server failed to listen on 'any' <ipv4> 0. Error: 0x277a. To proceed, notify your system administrator.
数据:
0000: a8 65 00 00 10 00 00 00 ¨e......
0008: 1b 00 00 00 59 00 4c 00 ....Y.L.
0010: 2d 00 32 00 30 00 31 00 -.2.0.1.
0018: 33 00 30 00 31 00 32 00 3.0.1.2.
0020: 35 00 32 00 30 00 31 00 5.2.0.1.
0028: 32 00 5c 00 53 00 51 00 2.\.S.Q.
0030: 4c 00 45 00 58 00 50 00 L.E.X.P.
0038: 52 00 45 00 53 00 53 00 R.E.S.S.
0040: 00 00 00 00 00 00 ......
事件类型: 错误
事件来源: MSSQL$SQLEXPRESS
事件种类: Server
事件 ID: 17182
日期: 2016-6-18
事件: 19:53:34
用户: N/A
计算机: YL-201301252012
描述:
TDSSNIClient initialization failed with error 0x277a, status code 0xa. Reason: Unable to initialize the TCP/IP listener. The requested service provider could not be loaded or initialized.
数据:
0000: 1e 43 00 00 10 00 00 00 .C......
0008: 1b 00 00 00 59 00 4c 00 ....Y.L.
0010: 2d 00 32 00 30 00 31 00 -.2.0.1.
0018: 33 00 30 00 31 00 32 00 3.0.1.2.
0020: 35 00 32 00 30 00 31 00 5.2.0.1.
0028: 32 00 5c 00 53 00 51 00 2.\.S.Q.
0030: 4c 00 45 00 58 00 50 00 L.E.X.P.
0038: 52 00 45 00 53 00 53 00 R.E.S.S.
0040: 00 00 00 00 00 00 ......
事件类型: 错误
事件来源: MSSQL$SQLEXPRESS
事件种类: Server
事件 ID: 17182
日期: 2016-6-18
事件: 19:53:34
用户: N/A
计算机: YL-201301252012
描述:
TDSSNIClient initialization failed with error 0x277a, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The requested service provider could not be loaded or initialized.
数据:
0000: 1e 43 00 00 10 00 00 00 .C......
0008: 1b 00 00 00 59 00 4c 00 ....Y.L.
0010: 2d 00 32 00 30 00 31 00 -.2.0.1.
0018: 33 00 30 00 31 00 32 00 3.0.1.2.
0020: 35 00 32 00 30 00 31 00 5.2.0.1.
0028: 32 00 5c 00 53 00 51 00 2.\.S.Q.
0030: 4c 00 45 00 58 00 50 00 L.E.X.P.
0038: 52 00 45 00 53 00 53 00 R.E.S.S.
0040: 00 00 00 00 00 00 ......
事件类型: 错误
事件来源: MSSQL$SQLEXPRESS
事件种类: Server
事件 ID: 17826
日期: 2016-6-18
事件: 19:53:34
用户: N/A
计算机: YL-201301252012
描述:
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.
数据:
0000: a2 45 00 00 12 00 00 00 ¢E......
0008: 1b 00 00 00 59 00 4c 00 ....Y.L.
0010: 2d 00 32 00 30 00 31 00 -.2.0.1.
0018: 33 00 30 00 31 00 32 00 3.0.1.2.
0020: 35 00 32 00 30 00 31 00 5.2.0.1.
0028: 32 00 5c 00 53 00 51 00 2.\.S.Q.
0030: 4c 00 45 00 58 00 50 00 L.E.X.P.
0038: 52 00 45 00 53 00 53 00 R.E.S.S.
0040: 00 00 00 00 00 00 ......
事件类型: 错误
事件来源: MSSQL$SQLEXPRESS
事件种类: Server
事件 ID: 17120
日期: 2016-6-18
事件: 19:53:34
用户: N/A
计算机: YL-201301252012
描述:
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
数据:
0000: e0 42 00 00 10 00 00 00 àB......
0008: 1b 00 00 00 59 00 4c 00 ....Y.L.
0010: 2d 00 32 00 30 00 31 00 -.2.0.1.
0018: 33 00 30 00 31 00 32 00 3.0.1.2.
0020: 35 00 32 00 30 00 31 00 5.2.0.1.
0028: 32 00 5c 00 53 00 51 00 2.\.S.Q.
0030: 4c 00 45 00 58 00 50 00 L.E.X.P.
0038: 52 00 45 00 53 00 53 00 R.E.S.S.
0040: 00 00 00 00 00 00 ......
------------------------------
不清楚错误代码0x277a表示什么错误信息;
大家有谁遇到过这种问题,麻烦给个建议,谢谢!