Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In order to debug a SQL Server 2008 stored procedure, I would like to change the account that the SQL Server (MSSQLSrver) service is running under, namely, changing the account from "Network Service" to my current user account.

However, if something goes wrong, I would like to be able to change it back and I am concerned that since this is a built in account for which I never knew the password, that I will not be able to set it back w/o knowing what the password is.

Will this be an issue?

share|improve this question
up vote 3 down vote accepted

You should be able to change it back by going in to Service Properties and changing "Log on as" to "NETWORK SERVICE" (use "Browse" and it should populate the password fields for you).

alt text

share|improve this answer
Hm, don't know why but this didn't work for me. The password fields are being filled in, but when trying to save the changes I get a dialog saying Please enter a valid password. Any clues? – Oliver Jun 5 '13 at 16:59
You have to clear the password fields and it will enter them automatically when you click ok. – geo1701 Sep 28 '13 at 7:34

To change it back enter for the field This account: NT AUTHORITY\NetworkService, then clear the password (suggested with dots) and select OK.

Now you can start the service again.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .