x

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.

more ▼

asked Nov 14 '09 at 07:39 AM in Default

S Graham gravatar image

S Graham
12 1 1 1

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

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
more ▼

answered Nov 16 '09 at 06:31 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

(comments are locked)
10|1200 characters needed characters left

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?

more ▼

answered Nov 14 '09 at 11:40 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 15 '09 at 06:54 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 76 79 82

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 16 '09 at 06:12 AM

S Graham gravatar image

S Graham
12 1 1 1

What network protocols do you have enabled?
Nov 16 '09 at 10:56 AM Blackhawk-17
Also, could you copy the error, and a few that happened before, from the SQL error log please.
Nov 16 '09 at 11:02 AM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

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! :-)

more ▼

answered Nov 18 '09 at 06:33 AM

S Graham gravatar image

S Graham
12 1 1 1

Glad I could help.
Nov 18 '09 at 07:06 AM Matt Whitfield ♦♦
Simon, make sure you mark Matt's answer as the correct one by clicking on the tick!
Nov 19 '09 at 07:02 AM Melvyn Harbour 1 ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x83
x30

asked: Nov 14 '09 at 07:39 AM

Seen: 5748 times

Last Updated: Nov 14 '09 at 07:39 AM