首页 新闻 会员 周边

sql server 2008启动服务是:提示请求失败或者服务无及时响应

-1
悬赏园豆:10 [已解决问题] 解决于 2012-12-14 16:48

这是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.

Sam_Y的主页 Sam_Y | 初学一级 | 园豆:132
提问于:2012-12-10 23:36
< >
分享
最佳答案
-1

把服务的端口修改一下

收获园豆:5
2012 | 高人七级 |园豆:21230 | 2012-12-11 08:34

修改了还是不行。之前我用的是另外一个系统账号,现在换成了系统内置账号。我在想是不是因为权限问题,但是我又觉得内置账号的权限应该更大撒

Sam_Y | 园豆:132 (初学一级) | 2012-12-11 15:26

谢谢,我的也出现这个问题,把端口改了就成功启动了。多谢咯

Dhoopu | 园豆:10 (初学一级) | 2013-01-29 10:29
其他回答(2)
0

是不是你安装了什么软件占用了端口

chenping2008 | 园豆:9836 (大侠五级) | 2012-12-11 09:24

没有,就是换了个系统账号而已!之前我用的是另外一个系统账号,现在换成了系统内置账号。我在想是不是因为权限问题,但是我又觉得内置账号的权限应该更大撒

支持(0) 反对(0) Sam_Y | 园豆:132 (初学一级) | 2012-12-11 15:27
0

估计得重装了。

收获园豆:5
jerry-Tom | 园豆:4077 (老鸟四级) | 2012-12-11 10:32

看来也只有这样了。

支持(0) 反对(0) Sam_Y | 园豆:132 (初学一级) | 2012-12-11 15:27
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册