服务器错误信息0X2740,mssql2008R2 无法启动 通常每个套接字地址(协议/网络地址/端口)只允许使用一次...

启动服务的时候，报如下错误:

开始检查日志：

SQL Server 无法生成 FRunCM 线程。请查看 SQL Server 错误日志和 Windows 事件日志，获取有关可能发生的相关问题的信息。

由于网络库中存在内部错误，所以无法启动网络库。要确定原因，请查看错误日志中紧位于此错误之前的那些错误。

TDSSNIClient 初始化失败，出现错误 0x2740，状态代码 0x1。原因: 初始化失败，出现基础结构错误。请检查以前的错误。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

TDSSNIClient 初始化失败，出现错误 0x2740，状态代码 0xa。原因: 无法初始化 TCP/IP 侦听器。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

服务器 TCP 提供程序无法在 [ ‘any’ 1433] 上侦听。TCP 端口已在使用中。

服务器正在侦听 [‘any’ 1433]。

Mysql日志：

2011-05-26 09:46:58.25 Server      Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)

Apr  2 2010 15:48:46

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7600: )

2011-05-26 09:46:58.25 Server      (c) Microsoft Corporation.

2011-05-26 09:46:58.25 Server      All rights reserved.

2011-05-26 09:46:58.25 Server      Server process ID is 7864.

2011-05-26 09:46:58.25 Server      System Manufacturer: ‘OEM’, System Model: ‘OEM’.

2011-05-26 09:46:58.25 Server      Authentication mode is MIXED.

2011-05-26 09:46:58.25 Server      Logging SQL Server messages in file ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG’.

2011-05-26 09:46:58.25 Server      This instance of SQL Server last reported using a process ID of 7576 at 2011/5/26 9:45:21 (local) 2011/5/26 1:45:21 (UTC). This is an informational message only; no user action is required.

2011-05-26 09:46:58.25 Server      Registry startup parameters:

-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf

-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG

-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

2011-05-26 09:46:58.27 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2011-05-26 09:46:58.27 服务器         Detected 2 CPUs. This is an informational message; no user action is required.

2011-05-26 09:46:58.29 服务器         Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.

2011-05-26 09:46:58.34 服务器         Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

2011-05-26 09:46:58.36 spid7s      Starting up database ‘master’.

2011-05-26 09:46:58.47 spid7s      Resource governor reconfiguration succeeded.

2011-05-26 09:46:58.47 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.

2011-05-26 09:46:58.47 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.

2011-05-26 09:46:58.48 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = ‘MSSQLSERVER’.

2011-05-26 09:46:58.51 spid7s      SQL Trace ID 1 was started by login “sa”.

2011-05-26 09:46:58.51 spid7s      Starting up database ‘mssqlsystemresource’.

2011-05-26 09:46:58.55 spid7s      The resource database build version is 10.50.1600. This is an informational message only. No user action is required.

2011-05-26 09:46:58.63 spid10s     Starting up database ‘model’.

2011-05-26 09:46:58.63 spid7s      Server name is ‘NQ’. This is an informational message only. No user action is required.

2011-05-26 09:46:58.78 服务器         A self-generated certificate was successfully loaded for encryption.

2011-05-26 09:46:58.78 服务器         Server is listening on [ ‘any’ 1433].

2011-05-26 09:46:58.78 服务器         错误: 26023，严重性: 16，状态: 1。

2011-05-26 09:46:58.78 服务器         Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.

2011-05-26 09:46:58.79 服务器         错误: 17182，严重性: 16，状态: 1。

2011-05-26 09:46:58.79 服务器         TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: 无法初始化 TCP/IP 侦听器。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

2011-05-26 09:46:58.79 服务器         错误: 17182，严重性: 16，状态: 1。

2011-05-26 09:46:58.79 服务器        TDSSNIClient initialization failed with error 0x2740, status code 0x1. Reason: 初始化失败，出现基础结构错误。请检查以前的错误。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

2011-05-26 09:46:58.79 服务器         错误: 17826，严重性: 18，状态: 3。

2011-05-26 09:46:58.79 服务器         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.

2011-05-26 09:46:58.79 服务器         错误: 17120，严重性: 16，状态: 1。

2011-05-26 09:46:58.79 服务器         SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

2011-05-26 09:46:58.81 spid10s     Clearing tempdb database.

2011-05-26 09:46:59.00 spid13s     A new instance of the full-text filter daemon host process has been successfully started.

2011-05-26 09:46:59.11 spid13s     Starting up database ‘msdb’.

协议/IP可以被程序多次利用，但是端口只能被单一程序进程占用。想想吧，最近在服务器上安装过什么？

查看端口被哪个无耻的进程占用了！！！

命令提示符：

C:\>netstat -ano | find “1433”

TCP    127.0.0.1:1433         127.0.0.1:3308         ESTABLISHED     1988

TCP    127.0.0.1:3308         127.0.0.1:1433         ESTABLISHED     2024

C:\>

C:\>tasklist | find “1988”

MuseMailSvr.exe               1988 Services                   0      7,664 K

今早上刚安装了一个邮件服务器软件，就它了，先卸载吧。之后再次启动mssql服务，OK了~

专注于 服务器运维与web架构

E-mail：venus#rootop.org