How to change SQL Server services login account information (Enterprise Manager)

SQL Server Setup Help

SQL Server Setup Help

How to change SQL Server services login account information (Enterprise Manager)

Note  If you are running Microsoft® Windows® 2000 and want to use the Windows 2000 Encrypted File System to encrypt any Microsoft SQL Server™ files, you must unencrypt the files before you can change the SQL Server service accounts. If you do not unencrypt the files and then reset the SQL Server service accounts, you cannot unencrypt the files.

To change the MSSQLServer service login (Enterprise Manager)

  1. Expand a server group.

  2. Right-click a server, and then click Properties.

  3. In the SQL Server Properties dialog box, click the Security tab.

  4. In the Startup service account box, the option for This Account is selected, indicating that the SQL Server service account is a Windows domain account. Enter changes as necessary for the account and password.

To change the SQLServerAgent service login (Enterprise Manager)

Note  You can change the SQLServerAgent service account to a non Microsoft Windows NT® 4.0 administrator account. However, the Windows NT 4.0 account must be a member of the sysadmin fixed server role to run SQL Server Agent.

  1. Expand a server group, and then expand a server.

  2. Expand Management.

  3. Right-click SQL Server Agent, and then click Properties.

  4. In the SQL Server Agent Properties dialog box, click the General tab.

  5. In the Service startup account box, enter the appropriate account and password.

See Also

Creating SQL Server Services User Accounts

Changing Passwords and User Accounts