Assigning permissions and roles in SQL Server 2000 databases

You must add the Vault Service account to the msdb system database and grant the required permissions to the Vault Service account.

To add the Vault Service account to the msdb system database

  1. On the SQL Server computer, start Enterprise Manager for SQL Server 2000.

  2. Select the required SQL Server.

  3. Expand the Databases container, and then expand the msdb container.

  4. Right-click Users, and then select New Database User.

  5. In the Login name box, enter the domain and the user name of the Vault Service account, in the form domain\user_name.

  6. In the User name box, enter a new user name.

  7. Click OK.

To grant the permissions to the Vault Service account

  1. Right-click the new user that you just created, and then click Properties.

  2. Click Permissions.

  3. Grant SELECT permission for the following objects:

    • sysjobs

    • sysjobschedules

    • sysjobservers

    • sysjobsteps

  4. By default the public role has execute permission on the following stored procedures. Grant execute permission on these procedures if it is not already granted:

    • sp_add_job

    • sp_add_jobschedule

    • sp_add_jobserver

    • sp_add_jobstep