Network Service Account password

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?

2 Answers

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).

2

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy