Error: The SELECT permission was denied on the object 'syscategories', database 'msdb', schema 'dbo'. The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'" when adding a schedule for a task or queue."

This error is encountered when adding a schedule for a task or queue, it means that the database user, usually NT Authority\Network Service, does not have rights to the msdb system database.
-Finding your DB user account-

1. Open IIS 
- Start >> Run >> 'inetmgr'
2. Find the application pool in which CRM is running
- Select the application pool and choose 'View Applications' to varify
3. Select the application pool and choose 'Advanced Settings...'
- Make a note of the Identity, this is usually 'NetworkService'. In the database this will be 'NT Authority\Network Service'
4. Expand Sites >> Default to find your CRM application
5. Select the application and 'Explore'
- A folder window will open
6. Find web.config and edit it with Notepad
7. Search for 'connectionstring'
- If your application is using 'integrated security=sspi' your database user will most likley be 'NT Authority\Network Service'
- If your connection string specifies a user you will need to refer to that user account in the following steps.

-Fix the error-

1. Open Microsoft SQL Management Studio
2. Log into your database
3. Expand the Security node
4. Find your user ('NT Authority\Network Service')
5. Right click the user and choose 'Properties'
6. Choose 'User Mapping'
7. Make sure that the user is mapped to the 'msdb' database and the 'BBAPPFXSERVICEROLE' database role.

Environment

 2.93 ; 2.94 ; 2.9.1001

Was this article helpful?