Export (0) Print
Expand All

How to: Change the Service Startup Account for SQL Server (SQL Server Configuration Manager)

New: 5 December 2005

You can change the Microsoft Windows account under which the SQL Server service runs. For more information, see Setting Up Windows Service Accounts.

ms345578.note(en-US,SQL.90).gifImportant:
When you change the service startup account for SQL Server, the service must be restarted for the change to take effect. When the service is restarted, all databases associated with that instance of SQL Server will be unavailable until the service successfully restarts. If you need to change the service startup account, make sure you do so during regularly scheduled maintenance or when the databases can be taken offline without interrupting daily operations.

  1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

  2. In SQL Server Configuration Manager, click SQL Server 2005 Services.

  3. In the details pane, right-click the name of the SQL Server instance for which you want to change the service startup account, and then click Properties.

  4. In the SQL Server <instancename> Properties dialog box, click the Log On tab, and select a Log on as account type.

  5. After selecting the new service startup account, click OK.

    A message box asks whether you want to restart the SQL Server service.

  6. Click Yes, and then close SQL Server Configuration Manager.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft