这是log日志
2012-12-10 23:28:51.06 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
2012-12-10 23:28:51.08 Server (c) 2005 Microsoft Corporation. 2012-12-10 23:28:51.08 Server All rights reserved. 2012-12-10 23:28:51.08 Server Server process ID is 4552. 2012-12-10 23:28:51.08 Server System Manufacturer: 'LENOVO', System Model: '0616A17'. 2012-12-10 23:28:51.08 Server Authentication mode is MIXED. 2012-12-10 23:28:51.08 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2012-12-10 23:28:51.08 Server This instance of SQL Server last reported using a process ID of 5692 at 2012/12/10 23:27:14 (local) 2012/12/10 15:27:14 (UTC). This is an informational message only; no user action is required. 2012-12-10 23:28:51.08 Server Registry startup parameters: -d E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf -e E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG -l E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2012-12-10 23:28:51.12 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2012-12-10 23:28:51.12 服务器 Detected 2 CPUs. This is an informational message; no user action is required. 2012-12-10 23:28:51.18 服务器 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. 2012-12-10 23:28:56.26 服务器 Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2012-12-10 23:28:56.29 spid7s Starting up database 'master'. 2012-12-10 23:28:56.45 spid7s Resource governor reconfiguration succeeded. 2012-12-10 23:28:56.45 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2012-12-10 23:28:56.45 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2012-12-10 23:28:56.45 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2012-12-10 23:28:56.50 spid7s SQL Trace ID 1 was started by login "sa". 2012-12-10 23:28:56.50 spid7s Starting up database 'mssqlsystemresource'. 2012-12-10 23:28:56.51 spid7s The resource database build version is 10.00.1600. This is an informational message only. No user action is required. 2012-12-10 23:28:56.87 spid10s Starting up database 'model'. 2012-12-10 23:28:56.87 spid7s Server name is 'SEN-PC'. This is an informational message only. No user action is required. 2012-12-10 23:28:57.26 服务器 A self-generated certificate was successfully loaded for encryption. 2012-12-10 23:28:57.28 服务器 Server is listening on [ 'any' <ipv6> 1433]. 2012-12-10 23:28:57.28 服务器 错误: 26023,严重性: 16,状态: 1。 2012-12-10 23:28:57.28 服务器 Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use. 2012-12-10 23:28:57.28 服务器 错误: 17182,严重性: 16,状态: 1。 2012-12-10 23:28:57.28 服务器 TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: 无法初始化 TCP/IP 侦听器。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。
2012-12-10 23:28:57.28 服务器 错误: 17182,严重性: 16,状态: 1。 2012-12-10 23:28:57.28 服务器 TDSSNIClient initialization failed with error 0x2740, status code 0x1. Reason: 初始化失败,出现基础结构错误。请检查以前的错误。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。
2012-12-10 23:28:57.28 服务器 错误: 17826,严重性: 18,状态: 3。 2012-12-10 23:28:57.28 服务器 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. 2012-12-10 23:28:57.28 服务器 错误: 17120,严重性: 16,状态: 1。 2012-12-10 23:28:57.28 服务器 SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. 2012-12-10 23:28:57.30 spid10s Clearing tempdb database. 2012-12-10 23:28:57.49 spid13s A new instance of the full-text filter daemon host process has been successfully started. 2012-12-10 23:28:57.57 spid15s Starting up database 'ReportServerTempDB'. 2012-12-10 23:28:57.57 spid13s Starting up database 'msdb'. 2012-12-10 23:28:57.57 spid14s Starting up database 'ReportServer'. 2012-12-10 23:28:57.57 spid17s Starting up database 'sdpmsnew'. 2012-12-10 23:28:57.57 spid18s Starting up database 'sdpmsnewa'. Cannot close event log because there are still event handle users active.
把服务的端口修改一下
修改了还是不行。之前我用的是另外一个系统账号,现在换成了系统内置账号。我在想是不是因为权限问题,但是我又觉得内置账号的权限应该更大撒
谢谢,我的也出现这个问题,把端口改了就成功启动了。多谢咯
是不是你安装了什么软件占用了端口
没有,就是换了个系统账号而已!之前我用的是另外一个系统账号,现在换成了系统内置账号。我在想是不是因为权限问题,但是我又觉得内置账号的权限应该更大撒
估计得重装了。
看来也只有这样了。