求助：SQL Server 2008 SP1无法启动服务！

[IoriWong]

我用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.

[claro]

如果你什么都没做，这样是很奇怪。

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

试着将SQL服务的登录身份换成 localsystem 试试。

[--小F--]

应该是注册表的内容被损坏 有可能是你在清理注册表的时候出的问题

还是建议重新安装 要简单很多

[chuanzhang5687]

执行 dbcc checkdb(msdb) 语句，检查一下 msdb 数据库的完整性。
如果有错误，执行 dbcc checkdb(msdb,repair_fast) 语句，试试修复 msdb 数据库。

[chuanzhang5687]

建议重新安装

[AcHerat]

cmd下net start mssqlserver也不行么？

[快溜]

卸载了重新装吧，比你查找问题更方便一些。

[liangyong1107]

此问题我之前也遇到过，楼主可以考虑把关于SQLSERVER所有的服务都停掉，然后在重新启动那个启动不了的服务试试。。

[IoriWong]

[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]

试了，没有作用。

感谢楼上各位！

[geniuswjt]

win7做开发确实很难受

[AcHerat]

1、也有可能是单用户的模式影响的，恢复为多用户看看。

2、修复下master库看看

3、重新安装SQL

[勿勿]

重装吧。快的很

[fanzhouqi]

从错误日志里面 找不到 有用的

支持5l的说法