SQL Server服务启动不了,查找日志
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG下的 ERRORLOG 用记事本打开
Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use.
2016-01-20 10:32:57.82 服务器 错误: 17182,严重性: 16,状态: 1。
2016-01-20 10:32:57.82 服务器 TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2016-01-20 10:32:57.82 服务器 错误: 17182,严重性: 16,状态: 1。
2016-01-20 10:32:57.82 服务器 TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2016-01-20 10:32:57.82 服务器 错误: 17826,严重性: 18,状态: 3。
2016-01-20 10:32:57.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.
2016-01-20 10:32:57.82 服务器 错误: 17120,严重性: 16,状态: 1。
2016-01-20 10:32:57.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.
从日志可看出端口1433被占,用netstat -aon|findstr "1433"发现占用此端口的就是sqlserver,真是莫名其妙,也查不出所以然,只好改端口
打开 SQL Server Configuation Manager,SQL Server 2005网络配置 ->SQL2005协议 ->TCP/IP->属性,在IP地址一栏,把IP1 127.0.0.1和 IPAll的TCP端口改成你想要的,如9033,再此启动服务,OK
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG下的 ERRORLOG 用记事本打开
Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use.
2016-01-20 10:32:57.82 服务器 错误: 17182,严重性: 16,状态: 1。
2016-01-20 10:32:57.82 服务器 TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2016-01-20 10:32:57.82 服务器 错误: 17182,严重性: 16,状态: 1。
2016-01-20 10:32:57.82 服务器 TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2016-01-20 10:32:57.82 服务器 错误: 17826,严重性: 18,状态: 3。
2016-01-20 10:32:57.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.
2016-01-20 10:32:57.82 服务器 错误: 17120,严重性: 16,状态: 1。
2016-01-20 10:32:57.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.
从日志可看出端口1433被占,用netstat -aon|findstr "1433"发现占用此端口的就是sqlserver,真是莫名其妙,也查不出所以然,只好改端口
打开 SQL Server Configuation Manager,SQL Server 2005网络配置 ->SQL2005协议 ->TCP/IP->属性,在IP地址一栏,把IP1 127.0.0.1和 IPAll的TCP端口改成你想要的,如9033,再此启动服务,OK