这个SQL2008快气死我了。在我的64win7上现在是10次有一到两次能开机自启动,其他时候都不能自启动。您说的错误信息是这个吗? 2014-03-16 08:19:23.61 Server Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)2014-03-16 08:19:24.21 Server (c) 2005 Microsoft Corporation. 2014-03-16 08:19:24.21 Server All rights reserved. 2014-03-16 08:19:24.21 Server Server process ID is 3456. 2014-03-16 08:19:24.21 Server System Manufacturer: 'LENOVO', System Model: '20216'. 2014-03-16 08:19:24.21 Server Authentication mode is MIXED. 2014-03-16 08:19:24.21 Server Logging SQL Server messages in file 'D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2014-03-16 08:19:24.21 Server This instance of SQL Server last reported using a process ID of 5132 at 2014/3/16 4:25:20 (local) 2014/3/15 20:25:20 (UTC). This is an informational message only; no user action is required. 2014-03-16 08:19:24.21 Server Registry startup parameters: -d D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf -e D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG -l D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2014-03-16 08:19:24.49 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2014-03-16 08:19:24.88 服务器 Detected 8 CPUs. This is an informational message; no user action is required. 2014-03-16 08:19:24.92 服务器 SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure. 2014-03-16 08:19:25.14 服务器 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. 2014-03-16 08:19:27.88 服务器 Node configuration: node 0: CPU mask: 0x000000ff Active CPU mask: 0x000000ff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2014-03-16 08:19:28.51 spid7s Starting up database 'master'. 2014-03-16 08:19:29.79 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2014-03-16 08:19:30.96 spid7s Resource governor reconfiguration succeeded. 2014-03-16 08:19:31.05 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2014-03-16 08:19:31.05 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2014-03-16 08:19:31.72 spid7s SQL Trace ID 1 was started by login "sa". 2014-03-16 08:19:31.73 spid7s Starting up database 'mssqlsystemresource'. 2014-03-16 08:19:31.82 spid7s The resource database build version is 10.00.5500. This is an informational message only. No user action is required. 2014-03-16 08:19:33.34 spid10s Starting up database 'model'. 2014-03-16 08:19:33.62 spid7s Server name is 'ZZHWIN7-64-PC'. This is an informational message only. No user action is required. 2014-03-16 08:19:34.87 spid10s Clearing tempdb database. 2014-03-16 08:19:40.79 spid10s Starting up database 'tempdb'. 2014-03-16 08:19:41.60 服务器 A self-generated certificate was successfully loaded for encryption. 2014-03-16 08:19:41.72 服务器 Server is listening on [ 'any' <ipv6> 1433]. 2014-03-16 08:19:41.72 服务器 Server is listening on [ 'any' <ipv4> 1433]. 2014-03-16 08:19:41.72 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2014-03-16 08:19:41.72 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ]. 2014-03-16 08:19:41.73 服务器 Server is listening on [ 'any' <ipv6> 1434]. 2014-03-16 08:19:41.74 服务器 Server is listening on [ 'any' <ipv4> 1434]. 2014-03-16 08:19:41.76 spid13s The Service Broker protocol transport is disabled or not configured. 2014-03-16 08:19:41.74 服务器 Dedicated admin connection support was established for listening remotely on port 1434. 2014-03-16 08:19:41.87 spid13s The Database Mirroring protocol transport is disabled or not configured. 2014-03-16 08:19:41.95 服务器 The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies. 2014-03-16 08:19:41.95 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required. 2014-03-16 08:19:42.00 spid13s Service Broker manager has started. 2014-03-16 08:19:43.46 登录 错误: 18456,严重性: 14,状态: 38。 2014-03-16 08:19:43.46 登录 Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. 原因: 无法打开明确指定的数据库。 [客户端: 10.73.5.250] 2014-03-16 08:19:44.19 spid24s A new instance of the full-text filter daemon host process has been successfully started. 2014-03-16 08:19:45.03 spid24s Starting up database 'msdb'. 2014-03-16 08:19:45.03 spid25s Starting up database 'ReportServer'. 2014-03-16 08:19:45.03 spid26s Starting up database 'ReportServerTempDB'. 2014-03-16 08:19:45.03 spid27s Starting up database 'SQGL'. 2014-03-16 08:19:45.03 spid28s Starting up database 'db_09'. 2014-03-16 08:19:45.03 spid29s Starting up database 'db_Student'. 2014-03-16 08:19:45.03 spid30s Starting up database 'db_NetStore'. 2014-03-16 08:19:45.03 spid31s Starting up database 'SQGL_Yuan'. 2014-03-16 08:19:45.03 spid32s Starting up database 'AdventureWorks'. 2014-03-16 08:19:45.03 spid33s Starting up database 'MINIUI'. 2014-03-16 08:19:46.82 spid7s Recovery completed for database ReportServerTempDB (database ID 6) in 1 second(s) (analysis 954 ms, redo 0 ms, undo 187 ms.) This is an informational message only. No user action is required. 2014-03-16 08:19:51.65 spid7s Recovery is complete. This is an informational message only. No user action is required. 2014-03-16 08:19:57.58 spid51 Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer. 2014-03-16 08:19:57.60 spid51 Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB.我现在被迫在启动组里手工加了一个批处理文件: net start mssqlserver这样是能解决问题,但实在是有些太怪了。到底怎么处理呀?
上面的错误信息是在:ERRORLOG当中的,还有两个错误文件。我把其中的信息再拿出来:FDLAUNCHERRORLOG文件中的错误信息: 2014-03-16 08:16:46.313 MSSQLFDLauncher service successfully started. 2014-03-16 08:19:43.734 MSSQLFDLauncher service received control message. 2014-03-16 08:19:44.194 MSSQLFDLauncher service successfully launched FDHost.exe Process(process id = 5832).log_359.trc这个文件打不开。无法看到里面的内容。
2014-03-16 08:19:23.61 Server Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86)
Sep 22 2011 00:28:06
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)2014-03-16 08:19:24.21 Server (c) 2005 Microsoft Corporation.
2014-03-16 08:19:24.21 Server All rights reserved.
2014-03-16 08:19:24.21 Server Server process ID is 3456.
2014-03-16 08:19:24.21 Server System Manufacturer: 'LENOVO', System Model: '20216'.
2014-03-16 08:19:24.21 Server Authentication mode is MIXED.
2014-03-16 08:19:24.21 Server Logging SQL Server messages in file 'D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2014-03-16 08:19:24.21 Server This instance of SQL Server last reported using a process ID of 5132 at 2014/3/16 4:25:20 (local) 2014/3/15 20:25:20 (UTC). This is an informational message only; no user action is required.
2014-03-16 08:19:24.21 Server Registry startup parameters:
-d D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Program Files (x86)\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2014-03-16 08:19:24.49 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2014-03-16 08:19:24.88 服务器 Detected 8 CPUs. This is an informational message; no user action is required.
2014-03-16 08:19:24.92 服务器 SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure.
2014-03-16 08:19:25.14 服务器 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.
2014-03-16 08:19:27.88 服务器 Node configuration: node 0: CPU mask: 0x000000ff Active CPU mask: 0x000000ff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2014-03-16 08:19:28.51 spid7s Starting up database 'master'.
2014-03-16 08:19:29.79 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2014-03-16 08:19:30.96 spid7s Resource governor reconfiguration succeeded.
2014-03-16 08:19:31.05 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2014-03-16 08:19:31.05 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2014-03-16 08:19:31.72 spid7s SQL Trace ID 1 was started by login "sa".
2014-03-16 08:19:31.73 spid7s Starting up database 'mssqlsystemresource'.
2014-03-16 08:19:31.82 spid7s The resource database build version is 10.00.5500. This is an informational message only. No user action is required.
2014-03-16 08:19:33.34 spid10s Starting up database 'model'.
2014-03-16 08:19:33.62 spid7s Server name is 'ZZHWIN7-64-PC'. This is an informational message only. No user action is required.
2014-03-16 08:19:34.87 spid10s Clearing tempdb database.
2014-03-16 08:19:40.79 spid10s Starting up database 'tempdb'.
2014-03-16 08:19:41.60 服务器 A self-generated certificate was successfully loaded for encryption.
2014-03-16 08:19:41.72 服务器 Server is listening on [ 'any' <ipv6> 1433].
2014-03-16 08:19:41.72 服务器 Server is listening on [ 'any' <ipv4> 1433].
2014-03-16 08:19:41.72 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2014-03-16 08:19:41.72 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2014-03-16 08:19:41.73 服务器 Server is listening on [ 'any' <ipv6> 1434].
2014-03-16 08:19:41.74 服务器 Server is listening on [ 'any' <ipv4> 1434].
2014-03-16 08:19:41.76 spid13s The Service Broker protocol transport is disabled or not configured.
2014-03-16 08:19:41.74 服务器 Dedicated admin connection support was established for listening remotely on port 1434.
2014-03-16 08:19:41.87 spid13s The Database Mirroring protocol transport is disabled or not configured.
2014-03-16 08:19:41.95 服务器 The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2014-03-16 08:19:41.95 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2014-03-16 08:19:42.00 spid13s Service Broker manager has started.
2014-03-16 08:19:43.46 登录 错误: 18456,严重性: 14,状态: 38。
2014-03-16 08:19:43.46 登录 Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. 原因: 无法打开明确指定的数据库。 [客户端: 10.73.5.250]
2014-03-16 08:19:44.19 spid24s A new instance of the full-text filter daemon host process has been successfully started.
2014-03-16 08:19:45.03 spid24s Starting up database 'msdb'.
2014-03-16 08:19:45.03 spid25s Starting up database 'ReportServer'.
2014-03-16 08:19:45.03 spid26s Starting up database 'ReportServerTempDB'.
2014-03-16 08:19:45.03 spid27s Starting up database 'SQGL'.
2014-03-16 08:19:45.03 spid28s Starting up database 'db_09'.
2014-03-16 08:19:45.03 spid29s Starting up database 'db_Student'.
2014-03-16 08:19:45.03 spid30s Starting up database 'db_NetStore'.
2014-03-16 08:19:45.03 spid31s Starting up database 'SQGL_Yuan'.
2014-03-16 08:19:45.03 spid32s Starting up database 'AdventureWorks'.
2014-03-16 08:19:45.03 spid33s Starting up database 'MINIUI'.
2014-03-16 08:19:46.82 spid7s Recovery completed for database ReportServerTempDB (database ID 6) in 1 second(s) (analysis 954 ms, redo 0 ms, undo 187 ms.) This is an informational message only. No user action is required.
2014-03-16 08:19:51.65 spid7s Recovery is complete. This is an informational message only. No user action is required.
2014-03-16 08:19:57.58 spid51 Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServer.
2014-03-16 08:19:57.60 spid51 Setting database option COMPATIBILITY_LEVEL to 100 for database ReportServerTempDB.我现在被迫在启动组里手工加了一个批处理文件:
net start mssqlserver这样是能解决问题,但实在是有些太怪了。到底怎么处理呀?
2014-03-16 08:16:46.313 MSSQLFDLauncher service successfully started.
2014-03-16 08:19:43.734 MSSQLFDLauncher service received control message.
2014-03-16 08:19:44.194 MSSQLFDLauncher service successfully launched FDHost.exe Process(process id = 5832).log_359.trc这个文件打不开。无法看到里面的内容。