How to set up a SQL Server service to log on under a different user account (Enterprise Manager)

To set up the MSSQLServer service to log on under a different user account

  1. Expand a server group.
  2. Right-click a server; then click Properties.
  3. Click the Security tab.
  4. In the Startup service account box, enter the appropriate account and password.

To set up the SQLServerAgent service to log on under a different user account

  1. Expand a server group; then expand a server.
  2. Expand Management.
  3. Right-click SQL Server Agent; then click Properties.
  4. Click the General tab.
  5. In the Service startup account box, enter the appropriate account and password.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.