Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Service not starting Expand / Collapse
Author
Message
Posted Thursday, September 2, 2010 7:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:04 AM
Points: 274, Visits: 1,468
SQL Server 2005 service is not starting, I checked the ErrorLog file and found the below error :

"2010-09-02 18:03:40.60 Server Error: 3411, Severity: 21, State: 1.
2010-09-02 18:03:40.60 Server Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall."


I tried to rebuild the master database by using following command :

"start /wait D:\setup.exe /qn INSTANCENAME=mssqm$ICT REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword"

This command ran successfully without any notification then I tried to start the SQL Server in single user mode by using -m; parameter but when I start the SQL Service it gives an error i.e. :

"Windows could not start the SQL Server on local computer. For more information review the system even log. If this is a non microsoft service, contact the service vendor and prefer to specific error code 3411 "

When I checked the event log it shows :

"The SQL Server (SQLFORMIRROR) service terminated with service-specific error 3411 (0xD53)."

I tried many ways but could not succeeded plz help.
Post #979492
Posted Saturday, September 4, 2010 10:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
Check if the database files are compressed. If yes remove the Compression option in the Operating System. Refer this

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #980642
Posted Sunday, September 5, 2010 12:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:04 AM
Points: 274, Visits: 1,468
No compression on database files.
Post #980747
Posted Sunday, September 5, 2010 12:51 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:16 PM
Points: 31,018, Visits: 15,456
Are there relevant entries in the SYSTEM or SECURITY Event logs?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #980824
Posted Sunday, September 5, 2010 4:31 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 4:02 AM
Points: 709, Visits: 1,422
Is the syntax of the command to reinstall master correct? I ask because you listed

"start /wait D:\setup.exe /qn INSTANCENAME=mssqm$ICT REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword"

supplying an instance name of mssqm$ICT yet your error is

"The SQL Server (SQLFORMIRROR) service terminated with service-specific error 3411 (0xD53)."

indicating your instance name with problems is SQLFORMIRROR.


Joie Andrew
"Since 1982"
Post #980857
Posted Monday, September 6, 2010 2:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:12 AM
Points: 225, Visits: 469
Post the windows even entries and also check what Andrew pointed out.

Rohit
Post #980952
Posted Tuesday, September 7, 2010 7:47 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 1, 2014 8:37 AM
Points: 4,769, Visits: 208
Like Steve mention post the relevant entries from the System, Security and Application Event logs.
Post #981582
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse