asked on

Random SQL Server 2005 SP2 service stop ?

Hi All,

I'm having problem with my SQL Server 2005 (Developer Edition) SP2 x64, it suddenly stop without no apparent reason, therefore i have to go to SS Config. mgr and then start it up manually everytime.

is there any Event viewer error that i should be aware of ?
at the moment the SQL Server (MSSQLServer) service is running under BUILTIN account\ Local System with AUTOMATIC start mode already set.

Any kind of suggestion and comments would be greatly appreciated.

Thanks

Raja Jegan R

Check out SQL Server Error Logs under SQL Server Agent in SSMS.
Also check for any errors in Event Viewer which captures any error messages

jjoz

ASKER

Here it is Jegan,

So far i could not find any obvious error message :-| apart from these two:

the SQL Agent error looks fine from here, could that be failed Windows Update (WSUS) at 3 AM stopped the SQL Service ?

Type:		Error
Date:		21/04/2010
Time:		2:13:04 PM
Event:		100
Source:		MSSQLServerADHelper
Category:	None
User:		N/A
Computer:	RSDB01
Description:
'0' is an invalid number of start up parameters. This service takes two start up parameters.
###############################################################################################
Type:		Error
Date:		27/04/2010
Time:		3:00:30 AM
Event:		1023
Source:		MsiInstaller
Category:	None
User:		\SYSTEM
Computer:	RSDB01
Description:
Product: Microsoft SQL Server 2005 (64-bit) - Update 'GDR 3080 for SQL Server Database Services 2005 (64-bit) ENU (KB970895)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970895_sqlrun_sql.msp.log.

Open in new window

SQL-Agent.jpg

SOLUTION