求助:SQL Server 2008 SP1无法启动服务!

IoriWong 2011-08-13 08:49:44
我用Win7 SP1。

SQL Server 2008 SP1安装后只用过一次(正常启动使用),隔了一周后再次想用时用配置管理器无法启动服务了(我平时少用,所以服务设置的是手动启动),网上查找的解决方法都不适用:

1.我的Windows用户只有一个Administrator
2.我未修改过Administrator的密码
3.我未修改过计算机名
4.IPAll正常,TCP/IP我看了下也正常
5.VIA是禁用的

到底是怎么了???真是个疑难问题!请各位大佬帮帮我,重装的话工作量太大了。。。

贴出启动时的日志:

2011-08-13 08:22:38.57 Server Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)

2011-08-13 08:22:38.65 Server (c) 2005 Microsoft Corporation.
2011-08-13 08:22:38.65 Server All rights reserved.
2011-08-13 08:22:38.65 Server Server process ID is 3684.
2011-08-13 08:22:38.65 Server System Manufacturer: 'LENOVO', System Model: '20022'.
2011-08-13 08:22:38.65 Server Authentication mode is MIXED.
2011-08-13 08:22:38.65 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-08-13 08:22:38.69 Server This instance of SQL Server last reported using a process ID of 3480 at 2011-08-04 23:59:02 (local) 2011-08-04 15:59:02 (UTC). This is an informational message only; no user action is required.
2011-08-13 08:22:38.69 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
2011-08-13 08:22:38.77 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-08-13 08:22:38.79 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2011-08-13 08:22:39.44 服务器 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-08-13 08:22:39.89 服务器 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.
2011-08-13 08:22:40.28 spid7s Starting up database 'master'.
2011-08-13 08:22:40.62 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-08-13 08:22:41.00 spid7s Resource governor reconfiguration succeeded.
2011-08-13 08:22:41.01 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2011-08-13 08:22:41.04 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2011-08-13 08:22:41.07 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2011-08-13 08:22:41.34 spid7s SQL Trace ID 1 was started by login "sa".
2011-08-13 08:22:41.36 spid7s Starting up database 'mssqlsystemresource'.
2011-08-13 08:22:41.40 spid7s The resource database build version is 10.00.2531. This is an informational message only. No user action is required.
2011-08-13 08:22:41.88 spid10s Starting up database 'model'.
2011-08-13 08:22:42.03 spid7s Server name is 'Computer Name'. This is an informational message only. No user action is required.
2011-08-13 08:22:42.27 spid10s Clearing tempdb database.
2011-08-13 08:22:42.59 spid10s Starting up database 'tempdb'.
2011-08-13 08:22:42.85 spid13s The Service Broker protocol transport is disabled or not configured.
2011-08-13 08:22:42.85 spid13s The Database Mirroring protocol transport is disabled or not configured.
2011-08-13 08:22:42.95 spid13s Service Broker manager has started.
2011-08-13 08:22:43.53 spid18s A new instance of the full-text filter daemon host process has been successfully started.
2011-08-13 08:22:43.67 spid19s Starting up database 'msdb'.
2011-08-13 08:22:43.67 spid18s Starting up database 'ReportServer'.
2011-08-13 08:22:43.67 spid20s Starting up database 'ReportServerTempDB'.
2011-08-13 08:22:44.27 spid7s Recovery is complete. This is an informational message only. No user action is required.
...全文
373 1 收藏 12
写回复
12 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
fanzhouqi 2011-08-14
从错误日志里面 找不到 有用的

支持5l的说法
回复
勿勿 2011-08-13
重装吧。快的很
回复
AcHerat 2011-08-13
1、也有可能是单用户的模式影响的,恢复为多用户看看。

2、修复下master库看看

3、重新安装SQL
回复
geniuswjt 2011-08-13
win7做开发确实很难受
回复
IoriWong 2011-08-13
[Quote=引用 3 楼 acherat 的回复:]
cmd下net start mssqlserver也不行么?
[/Quote]

试了一下,也是无法启动:

C:\Users\Administrator>net start mssqlserver
SQL Server (MSSQLSERVER) 服务正在启动 ..........................
SQL Server (MSSQLSERVER) 服务无法启动。

请键入 NET HELPMSG 3523 以获得更多的帮助。

但是SQL Full-text Filter Daemon Launcher启动了。

[Quote=引用 4 楼 liangyong1107 的回复:]
此问题我之前也遇到过,楼主可以考虑把关于SQLSERVER所有的服务都停掉,然后在重新启动那个启动不了的服务试试。。
[/Quote]

试了,没有作用。

感谢楼上各位!
回复
liangyong1107 2011-08-13
此问题我之前也遇到过,楼主可以考虑把关于SQLSERVER所有的服务都停掉,然后在重新启动那个启动不了的服务试试。。
回复
快溜 2011-08-13
卸载了重新装吧,比你查找问题更方便一些。
回复
AcHerat 2011-08-13
cmd下net start mssqlserver也不行么?
回复
chuanzhang5687 2011-08-13
建议重新安装
回复
chuanzhang5687 2011-08-13
执行 dbcc checkdb(msdb) 语句,检查一下 msdb 数据库的完整性。
如果有错误,执行 dbcc checkdb(msdb,repair_fast) 语句,试试修复 msdb 数据库。
回复
--小F-- 2011-08-13
应该是注册表的内容被损坏 有可能是你在清理注册表的时候出的问题

还是建议重新安装 要简单很多
回复
claro 2011-08-13
如果你什么都没做,这样是很奇怪。

看看可以启动的服务,登录身份是什么。

试着将SQL服务的登录身份换成 localsystem 试试。
回复
相关推荐
发帖
疑难问题
创建于2007-09-28

2.1w+

社区成员

MS-SQL Server 疑难问题
申请成为版主
帖子事件
创建了帖子
2011-08-13 08:49
社区公告
暂无公告