How to change SQL Server services login account information (Windows NT)

How to Install SQL Server 2000

How To

How to change SQL Server services login account information (Windows NT)

To change SQL Server services login account information (Windows NT)

  1. On the Start menu, point to Settings, and then click Control Panel.

  2. Double-click Services.

  3. In the Services dialog box, double-click MSSQLSERVER in the Service list.

    Note  For named instances, the instance name is included. For example, to modify the user account for Instance1, you double-click MSSQL$Instance1.

  4. In the Service dialog box, under Log on as, select This account, and then enter the changed account information.

  5. Repeat Steps 3 and 4 above for SQL Server Agent. In the Services dialog box, double-click SQLSERVERAGENT (or SQLAgent$Instance1 for a named instance), and then enter the changed account information in the Service dialog box.

  6. Start SQL Server Enterprise Manager, and change the user account information there, as well, for both SQL Server and SQL Server Agent For more information see How to change SQL Server services login account information (Enterprise Manager).