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
- Expand a server group.
- Right-click a server; then click Properties.
- Click the Security tab.
- 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
- Expand a server group; then expand a server.
- Expand Management.
- Right-click SQL Server Agent; then click Properties.
- Click the General tab.
- In the Service startup account box, enter the appropriate account and password.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.