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

To set up a SQL Server service to log on under a different user account

  1. On the Start menu, point to Settings, and then click Control Panel.
  2. Double-click Services.
  3. Double-click MSSQLServer or SQLServerAgent.
  4. In the Services dialog box, under Log on as, select This account, and then enter the account information.

Important If Microsoft Full-text Search is installed on the computer, do not change the MSSQLServer account information in the Services Control Panel applet. While the Microsoft Search service is always assigned to the local system account, it keeps track of the MSSQLServer service account. You must change the MSSQLServer service account in SQL Server Enterprise Manager for the Microsoft Search service to stay in synch.

  


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