S
Scott AWA
I can't get the SQL server MSSMLBIZ to start, even when I try to manually
start it, here is the error log:
2010-05-12 13:31:05.63 Server Microsoft SQL Server 2005 - 9.00.4053.00
(Intel X86)
May 26 2009 14:24:20
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 6.1 (Build 7600: )
2010-05-12 13:31:05.65 Server (c) 2005 Microsoft Corporation.
2010-05-12 13:31:05.65 Server All rights reserved.
2010-05-12 13:31:05.65 Server Server process ID is 4932.
2010-05-12 13:31:05.65 Server Authentication mode is WINDOWS-ONLY.
2010-05-12 13:31:05.68 Server Logging SQL Server messages in file
'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-05-12 13:31:05.68 Server This instance of SQL Server last reported
using a process ID of 4168 at 5/4/2010 2:34:50 PM (local) 5/4/2010 7:34:50 PM
(UTC). This is an informational message only; no user action is required.
2010-05-12 13:31:05.70 Server Registry startup parameters:
2010-05-12 13:31:05.73 Server -d c:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-05-12 13:31:05.73 Server -e c:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-05-12 13:31:05.73 Server -l c:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-05-12 13:31:05.73 Server -T 840
2010-05-12 13:31:05.73 Server -T 2324
2010-05-12 13:31:05.81 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2010-05-12 13:31:05.81 Server Detected 4 CPUs. This is an informational
message; no user action is required.
2010-05-12 13:31:06.42 Server 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.
2010-05-12 13:31:06.77 Server Database mirroring has been enabled on
this instance of SQL Server.
2010-05-12 13:31:06.86 spid5s Starting up database 'master'.
2010-05-12 13:31:07.20 spid5s Recovery is writing a checkpoint in
database 'master' (1). This is an informational message only. No user action
is required.
2010-05-12 13:31:07.48 spid5s SQL Trace ID 1 was started by login "sa".
2010-05-12 13:31:07.57 spid5s Starting up database 'mssqlsystemresource'.
2010-05-12 13:31:07.61 spid5s The resource database build version is
9.00.4035. This is an informational message only. No user action is required.
2010-05-12 13:31:08.05 spid8s Starting up database 'model'.
2010-05-12 13:31:08.05 spid5s Server name is 'SCOTTHAMMEL\MSSMLBIZ'.
This is an informational message only. No user action is required.
2010-05-12 13:31:08.07 spid5s Starting up database 'msdb'.
2010-05-12 13:31:08.75 spid8s Clearing tempdb database.
2010-05-12 13:31:08.88 Server A self-generated certificate was
successfully loaded for encryption.
2010-05-12 13:31:08.89 Server Server local connection provider is ready
to accept connection on [ \\.\pipe\SQLLocal\MSSMLBIZ ].
2010-05-12 13:31:08.89 Server Server local connection provider is ready
to accept connection on [ \\.\pipe\MSSQL$MSSMLBIZ\sql\query ].
2010-05-12 13:31:08.90 Server Dedicated administrator connection
support was not started because it is not available on this edition of SQL
Server. This is an informational message only. No user action is required.
2010-05-12 13:31:08.92 Server SQL Server is now ready for client
connections. This is an informational message; no user action is required.
2010-05-12 13:31:09.31 spid8s Starting up database 'tempdb'.
2010-05-12 13:31:09.62 spid5s Recovery is complete. This is an
informational message only. No user action is required.
2010-05-12 13:31:09.68 spid11s The Service Broker protocol transport is
disabled or not configured.
2010-05-12 13:31:09.69 spid11s The Database Mirroring protocol transport
is disabled or not configured.
2010-05-12 13:31:09.82 spid11s Service Broker manager has started.
2010-05-12 13:40:02.32 spid11s Service Broker manager has shut down.
2010-05-12 13:40:02.50 spid5s SQL Server is terminating in response to
a 'stop' request from Service Control Manager. This is an informational
message only. No user action is required.
2010-05-12 13:40:02.50 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
2010-05-12 13:40:02.53 spid5s Error: 17053, Severity: 16, State: 1.
2010-05-12 13:40:02.53 spid5s UpdateUptimeRegKey: Operating system
error 2(The system cannot find the file specified.) encountered.
Please help, thanks!
start it, here is the error log:
2010-05-12 13:31:05.63 Server Microsoft SQL Server 2005 - 9.00.4053.00
(Intel X86)
May 26 2009 14:24:20
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 6.1 (Build 7600: )
2010-05-12 13:31:05.65 Server (c) 2005 Microsoft Corporation.
2010-05-12 13:31:05.65 Server All rights reserved.
2010-05-12 13:31:05.65 Server Server process ID is 4932.
2010-05-12 13:31:05.65 Server Authentication mode is WINDOWS-ONLY.
2010-05-12 13:31:05.68 Server Logging SQL Server messages in file
'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-05-12 13:31:05.68 Server This instance of SQL Server last reported
using a process ID of 4168 at 5/4/2010 2:34:50 PM (local) 5/4/2010 7:34:50 PM
(UTC). This is an informational message only; no user action is required.
2010-05-12 13:31:05.70 Server Registry startup parameters:
2010-05-12 13:31:05.73 Server -d c:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-05-12 13:31:05.73 Server -e c:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-05-12 13:31:05.73 Server -l c:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-05-12 13:31:05.73 Server -T 840
2010-05-12 13:31:05.73 Server -T 2324
2010-05-12 13:31:05.81 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2010-05-12 13:31:05.81 Server Detected 4 CPUs. This is an informational
message; no user action is required.
2010-05-12 13:31:06.42 Server 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.
2010-05-12 13:31:06.77 Server Database mirroring has been enabled on
this instance of SQL Server.
2010-05-12 13:31:06.86 spid5s Starting up database 'master'.
2010-05-12 13:31:07.20 spid5s Recovery is writing a checkpoint in
database 'master' (1). This is an informational message only. No user action
is required.
2010-05-12 13:31:07.48 spid5s SQL Trace ID 1 was started by login "sa".
2010-05-12 13:31:07.57 spid5s Starting up database 'mssqlsystemresource'.
2010-05-12 13:31:07.61 spid5s The resource database build version is
9.00.4035. This is an informational message only. No user action is required.
2010-05-12 13:31:08.05 spid8s Starting up database 'model'.
2010-05-12 13:31:08.05 spid5s Server name is 'SCOTTHAMMEL\MSSMLBIZ'.
This is an informational message only. No user action is required.
2010-05-12 13:31:08.07 spid5s Starting up database 'msdb'.
2010-05-12 13:31:08.75 spid8s Clearing tempdb database.
2010-05-12 13:31:08.88 Server A self-generated certificate was
successfully loaded for encryption.
2010-05-12 13:31:08.89 Server Server local connection provider is ready
to accept connection on [ \\.\pipe\SQLLocal\MSSMLBIZ ].
2010-05-12 13:31:08.89 Server Server local connection provider is ready
to accept connection on [ \\.\pipe\MSSQL$MSSMLBIZ\sql\query ].
2010-05-12 13:31:08.90 Server Dedicated administrator connection
support was not started because it is not available on this edition of SQL
Server. This is an informational message only. No user action is required.
2010-05-12 13:31:08.92 Server SQL Server is now ready for client
connections. This is an informational message; no user action is required.
2010-05-12 13:31:09.31 spid8s Starting up database 'tempdb'.
2010-05-12 13:31:09.62 spid5s Recovery is complete. This is an
informational message only. No user action is required.
2010-05-12 13:31:09.68 spid11s The Service Broker protocol transport is
disabled or not configured.
2010-05-12 13:31:09.69 spid11s The Database Mirroring protocol transport
is disabled or not configured.
2010-05-12 13:31:09.82 spid11s Service Broker manager has started.
2010-05-12 13:40:02.32 spid11s Service Broker manager has shut down.
2010-05-12 13:40:02.50 spid5s SQL Server is terminating in response to
a 'stop' request from Service Control Manager. This is an informational
message only. No user action is required.
2010-05-12 13:40:02.50 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
2010-05-12 13:40:02.53 spid5s Error: 17053, Severity: 16, State: 1.
2010-05-12 13:40:02.53 spid5s UpdateUptimeRegKey: Operating system
error 2(The system cannot find the file specified.) encountered.
Please help, thanks!