Server Fault is a question and answer site for system and network administrators. 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

I try to install SQL server 2008 Express with Advanced Services. When it comes to the server configuration step, instead of getting NT AUTHORITY\LOCAL SERVICE in account name column, i have NT AUTHORITY\NetworkService. This is read only value, I can not change this value here. Why do I not see NT AUTHORITY\LOCAL SERVICE? is this happened because of sql server 2005 express already installed before? So, how can I change to "NT AUTHORITY\LOCAL SERVICE"? Do I need to set it in regedit or are there any other ways to do it?

share|improve this question

migrated from Oct 17 '09 at 4:27

This question came from our site for professional and enthusiast programmers.

Damned skimpy title. – John Saunders Oct 17 '09 at 3:09

It does not offer NT AUTHORITY\LOCAL SERVICE because that is an invalid installation account. Under LOCAL SERVICE the SQL Server won't be able to connect to AD and all sort of functionality will be broken, like anything related to EXECUTE AS and the cascade of features that use it and then the cascade of features that use features that use it etc etc.

share|improve this answer

You can go in after the install and change the service identity itself in the services console....

You can also use the Sql Server Configuration Manager after the install to make the change.

share|improve this answer
Thanks, i try that. – coder09 Oct 17 '09 at 3:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.