Configure sqlserver2000 to run with a separate user

1. Create an SQL user without any groups

 

2. c: \ Program Files \ Microsoft SQL Server read permission

C: \ Documents ents and settings Read and Write Permissions

SQL installation directory Read and Write Permissions

The root directory of the installation directory, for example, D: \ read permission

SQL backup folder Read and Write Permissions

 

3. First, set the SQLAgent running user in the service.

 

4. Open the Enterprise Manager and set the running user in property security.

 

Complete