needs help - MSSQL service won't start

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

needs help - MSSQL service won't start

Author

Topic

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2008-12-16 : 02:51:49

Hi experts.

Recently, my administrator removed the domain controller that is deployed on the database server - and to my horror, I am unable to log in any more.

Each time I try to start the service I got this

TITLE: Surface Area Configuration
------------------------------

The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service. (SQLSAC)

The problem i am sign in as an administrator account to resolve this issue. When I check the application log, I got the following error:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17049
Date: 12/16/2008
Time: 3:24:03 PM
User: N/A
Computer: SV06
Description:
Unable to cycle error log file from 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG.1' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG.2' due to OS error '5(Access is denied.)'. A process outside of SQL Server may be preventing SQL Server from reading the files. As a result, errorlog entries may be lost and it may not be possible to view some SQL Server errorlogs. Make sure no other processes have locked the file with write-only access."

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 99 42 00 00 10 00 00 00 ?B......
0008: 05 00 00 00 53 00 56 00 ....S.V.
0010: 30 00 36 00 00 00 00 00 0.6.....
0018: 00 00 ..

Help is greatly appreciated.

Thank you

Regards,

Eugene

check out my blog at http://www.aquariumlore.blogspot.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-16 : 03:30:30

Change owner for Agent Service to local network or similar.

E 12°55'05.63"
N 56°04'39.26"

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2008-12-16 : 03:38:54

Hi Peso

Quote: "Change owner for Agent Service to local network or similar."

Please can you tell me how do I do that or direct me to a source where I can find out how to do that? Appearantly I am googling the wrong words...

Regards,

Eugene

check out my blog at http://www.aquariumlore.blogspot.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-16 : 04:22:38

1) In Control Panel, choose Administrative Tools and Services.
2) For the SQL Server Agent in question, choose Properties
3) Switch to Log On tab
4) Choose Local system or choose a particular account to use for SQL Server Agent to start with

E 12°55'05.63"
N 56°04'39.26"

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2008-12-16 : 05:14:24

Thank you Peso.

you are a gem. Did anyone tell you that?

I was about to cry

as my boss was furious and I don't know what is happening. You just saved my job! :)

Regards,

Eugene

check out my blog at http://www.aquariumlore.blogspot.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-16 : 05:24:40

Thank you. Send me a postcard by snailmail. I collect postcards from around the world.

You should check the same property and log on account for the sql server service too.

E 12°55'05.63"
N 56°04'39.26"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-16 : 20:17:43

SO your administrator removed domain controller without notifying DBAs.

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2008-12-16 : 22:27:34

Sodeep,

yes. =( as a result all database connections died for all applications depending on database. The ERP was down as cannot connect to database and whole office was in an uproar - I was frantically switching to backup database server, using backup data, but the backup data is outdated (we backup once a month). sigh.

Regards,

Eugene

check out my blog at http://www.aquariumlore.blogspot.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-03 : 10:59:02

Postcards arrived on 29th of December.
Thank you!

E 12°55'05.63"
N 56°04'39.26"

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2009-01-04 : 20:42:12

Peso,

Welcome, hope you like the pics of screens of Singapore (half the world away from you). :)

regards,

Eugene

check out my blog at http://www.aquariumlore.blogspot.com

chtvnn
Starting Member

1 Post

Posted - 2009-05-22 : 00:13:27

Thank you so much Peso, it helps me much. :-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources