Help Can't start the SQL Service

Question

Help Can't start the SQL Service

junlong_9292

SSC-Addicted

Points: 402
More actions
July 6, 2012 at 6:41 am

#147166

As per the topic,
I can't seem to start my SQL services. It always give me this error. Any expert out there can help me?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Divine Flame SSCoach Points: 15943 More actions · Answer 1

junlong_9292 (7/6/2012)
As per the topic,
I can't seem to start my SQL services. It always give me this error. Any expert out there can help me?

What error do you get in the SQL Server error log file?

Sujeet Singh

junlong_9292 SSC-Addicted Points: 402 More actions · Answer 2

Hi Divine flame,

Thanks for your reply

this is the error i got when i tried to connect my SQL

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

What's in the SQL Server error log?

Those errors are meaningless, to see why the service won't start, we need to see the actual errors, which are in the error log. Just post the entire of the latest log file here (as text, not a screenshot)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

junlong_9292 SSC-Addicted Points: 402 More actions · Answer 4

Hi GilaMonster

Thanks for replying

this is the error

2012-07-06 20:11:42.22 Server Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)

Dec 10 2010 10:56:29

Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

2012-07-06 20:11:42.22 Server Server process ID is 7508.

2012-07-06 20:11:42.22 Server Authentication mode is WINDOWS-ONLY.

2012-07-06 20:11:42.22 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2012-07-06 20:11:42.22 Server This instance of SQL Server last reported using a process ID of 6556 at 06/07/2012 7:51:36 PM (local) 06/07/2012 11:51:36 AM (UTC). This is an informational message only; no user action is required.

2012-07-06 20:11:42.23 Server Registry startup parameters:

2012-07-06 20:11:42.23 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

2012-07-06 20:11:42.23 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

2012-07-06 20:11:42.23 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

2012-07-06 20:11:42.23 Server Error: 17113, Severity: 16, State: 1.

2012-07-06 20:11:42.23 Server Error 2(error not found) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

junlong_9292 (7/6/2012)
2012-07-06 20:11:42.23 Server Error 2(error not found) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

Is the file there? Don't think so.

Locate the master.mdf in your disk and change the startup parameters in the Configuration Manager.

If the file was lost, restore from backup.

-- Gianluca Sartori

junlong_9292 SSC-Addicted Points: 402 More actions · Answer 6

Hi,

May i ask will re-install solve this problem. If not, do i do system restore to the recent image or the most furthest one?

thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

yes, a reinstall of SQL Express will solve the issue, but that's a little extreme.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass