How to change SQL Server services login account information remotely (64-bit)
This topic applies only to SQL Server 2000 (64-bit).
Note This version of Microsoft® SQL Server™ 2000 (64-bit) does not install SQL Server Enterprise Manager. This procedure describes how to use SQL Server Enterprise Manager on the Microsoft Windows® 2000 operating system to remotely manage the 64-bit version of SQL Server 2000.
Note If Microsoft SQL Server files are encrypted, you must decrypt the files before you can change the SQL Server service accounts. If you do not decrypt the files and then reset the SQL Server service accounts, you cannot decrypt the files.
To change the MSSQLServer service login (Enterprise Manager)
- Expand a server group.
- Right-click a server, and then click Properties.
- In the SQL Server Properties dialog box, click the Security tab.
- 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.
Note For SQL Server to start successfully, the account must be a member of the local Administrators group on the remote computer where SQL Server is installed. To provide network access, it must also be a domain account.
To change the SQLServerAgent service login (Enterprise Manager)
Note The Windows account must be a member of the sysadmin fixed server role to run SQL Server Agent.
- Expand a server group, and then expand a server.
- Expand Management.
- Right-click SQL Server Agent, and then click Properties.
- In the SQL Server Agent Properties dialog box, click the General tab.
- In the Service startup account box, enter the appropriate account and password.
How to change SQL Server services login account information (64-bit)