question

S Graham avatar image
S Graham asked

Resetting 'Log on as' problems

Hi all,

When fiddling around using the SQL Server Configuration Tool yesterday, I changed the 'log on as' user to my domain user for all SQL Server services. This in turn stopped the service and when I try to start the service I get an error like 'Failed to respond in a timely fashion'. If I try resetting the 'log on as' users to Network Service and Local Service, I get an error saying 'Cannot find object or property'.

How can I reset these users and restart the SQL Server?

Many thanks.

sql-server-2008permissionsuser
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

Just a thought, have you tried changing the Log On As property through services control panel, rather than using the configuration manager?

  • Go to start -> run
  • type 'services.msc' and press enter
  • scroll down to the service for your instance (probably just called 'SQL Server')
  • right click
  • properties
  • second tab ('Log On')
  • click 'this account'
  • into the top edit box type 'NT AUTHORITY\NETWORK SERVICE'
  • don't worry about the password
  • click OK
  • close services control panel

an alternative step, which sometimes helps:

  • pray
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image
Blackhawk-17 answered

Was this a fresh install and had you rebooted prior to changing the users?

It is possible some DLLs wre not registered yet and that may be an underlying issue.

I would begin with a reboot to see if A) any delayed file actions completed, B) to clear the memory and C) it is Microsoft fix #1 :)

If the reboot does not alleviate the issue you may need to try a repair.

Are there any other issues showing up in the NT Event logs around the same time?

What O/S was the install on? Is this on a laptop/desktop/virtual machine/server/cluster?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor avatar image
Steve Jones - Editor answered

you might also be sure you log off and on with your account. new tokens should arrive with the "Log on as service property" and it's possible something might have gotten delayed. I also agree with Blackhawk's reboot idea.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

S Graham avatar image
S Graham answered

Hi all,

thanks for your responses. Just to fill you in a few more details.....

It was definitely not a fresh install and prior to my tinkering had been working for a good few months. I'm sure the machine had been rebooted several times after the SQL Server installation.

Its a Windows 2003 Standard Edition server. Looking at the error logs, I get the following reports....


Application Event Log

Event Type: Error Event Source: MSSQL$SQL2008 Event Category: Server Event ID: 17120 Date: 16/11/2009 Time: 09:00:57 User: N/A Computer: SKIP Description: SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


System Event Log

Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7024 Date: 16/11/2009 Time: 09:00:57 User: N/A Computer: SKIP Description: The SQL Server (SQL2008) service terminated with service-specific error 2148081668 (0x80092004).


I've tried rebooting again, and also tried logging out and back in as my user, but this hasn't helped. I still cannot change the 'log on as' property of either SQL Server or SQL Server Agent using the configuration manager.

WMI Provider Error: Cannot find object or property (0x80092004)

Any help would be much appreciated.

Many thanks.

2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What network protocols do you have enabled?
0 Likes 0 ·
Also, could you copy the error, and a few that happened before, from the SQL error log please.
0 Likes 0 ·
S Graham avatar image
S Graham answered

Many thanks Matt!

I managed to reset the 'Log On' properties for the SQL Server and the SQL Server Agent using the steps you provided. SQL Server now starts.

Lesson learnt! :-)

2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Glad I could help.
0 Likes 0 ·
Simon, make sure you mark Matt's answer as the correct one by clicking on the tick!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.