mssqlserver instance doesn't start

[Former Member]

i have install sql server std. edition 2005 and sap b1 2007 pl10 in windows xp system. it was working fine. but today when i started the system, the mssqlserver doesn't start even on local system. it gives error code 3417 when trying to start the service. i have checked there is no compression of folder. all protocols are enabled. what could be the reason

[Former Member]

no nothing happend lik this

[ken_halvorsen2]

Hi ASH7319 (if I may call you that?:)

I found a few suggestions in regards to your problem, although most of them do speak about compressions. You might want to check out these links:

http://www.tomrafteryit.net/sql-server-2005-express-error-3417/

http://decoding.wordpress.com/2008/08/25/sql-server-2005-expess-how-to-fix-error-3417/

The suggestions include:

1. Running SQLdiag found in C:\Program Files\Microsoft SQL Server\90\Tools\Binn.

2. right-clicked on SQL Services and changed the Log On to "Local System Account" with the box check

3. network authorization or password issues with the Servcies user account

4. restoring the db from a backup

Ken

[ken_halvorsen2]

You will want to check it there were any recent Windows patches install or authorizations changed.

[markus_doehr2]

> it gives error code 3417 when trying to start the service.

So I'd check the event log for SQL Server specific error message.

Markus