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