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
LVL 1
jjozAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
0
jjozAuthor Commented:
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
0
pnautaCommented:
jjoz,

The MSSQLServerADHelper is not a dependancy, so it should not be a reason.  The SQL Agent again, could not be a reason.  SQLAgent will not start when SQLServer is not running, but again, the other way round is not a problem.

Your SQL log shows no errors that are fatal.  The only remark I have is that apparently not everything is at SP2 level (build 3042), as some are at build 4035 (SP3).

Next step would be to have a look at your event logs.  Maybe something or someone killed the process.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

jjozAuthor Commented:
yes, that could be it man.
let me upgrade all of the components to SP3 and see how it goes.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Regret for the delay as I was in a short vacation..
Appplying SP3 with latest Cumulative updates might help you out.
Else let us know the startup accounts of SQL Server services and list of any major applications running in that server.. ( Resource intensive applications running in that machine can also be a cause for this).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jjozAuthor Commented:
yes it works man.
0
jjozAuthor Commented:
after installing SP3 now it works just fine :-)

Thanks guys.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.