SQL Server 2005 Service is stopping on its own - Windows XP

Hello Experts,

The SQL 2005 Service is has been stopping periodically on a Windows XP machine. Here is an excerpt from Windows Event viewer:

Event Type: Error
Event Source: MSSQL$GROUNDFISH
Event Category: (2)
Event ID: 8355
Date:  10/15/2013
Time:  12:02:46 PM
User:  N/A
Computer: GROUNDFISH
Description:
Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.
 
Here is another one:

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date:  10/14/2013
Time:  11:02:26 AM
User:  N/A
Computer: GROUNDFISH
Description:
The SQL Server (GROUNDFISH) service terminated with service-specific error 3417 (0xD59).


Does anyone know:

What exactly does Service Broker do and why would it be disabled?
Why would msdb be offline?
What does error 3417 mean?

Thanks!
SaxitalisAsked:
Who is Participating?
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.

geek_vjCommented:
Error 3417 typically occurs due to permission issue while accessing SQL Server data/log files on the disk

As such, please ensure that the SQL service account has full permissions to all the relevant SQL Server folders (especially where the system data & log files are present)

If you are using a sql server 2005 express edition, then do ensure that the disk is not compressed as express edition doesnt support compression.

Hope this helps!
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
SaxitalisAuthor Commented:
The SQL Server service account is logged on to LOCAL SYSTEM. Shouldn't this give it full permissions to the folders?

There is no option to add Local System to NTFS security at the file and folder level.

What am I missing here?

Thanks!
0
geek_vjCommented:
Have you checked the disk compression feature is in disabled state?

Also, please provide the SQL Server version and edition details
0
SaxitalisAuthor Commented:
It SQL Server 2005 Express - How do you check the disk compression feature?
0
SaxitalisAuthor Commented:
I think this was the issue - thanks!
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 XP

From novice to tech pro — start learning today.