Friday, February 17, 2012

Error setting up report subscription

I receive the following error when I try to save a subscription after configuring it. I appreciate any insight that anyone has.

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

The EXECUTE permission was denied on the object 'sp_add_category', database 'msdb', schema 'dbo'.

The account used by the Reporting Services Services doesn't have the appropriate permissions on the msdb database or permissions have been altered on the sp_add_category stored procedure. The account should have exec rights.|||

Ensure

1) SQL Agent is running

2) use the reporting services configuration manager to grant the report server service account rights to the report server database.

What it appears from above is your report server service account does not have sufficient permission to create Agent Jobs. This can be rectified by granting the service rights again.

-Lukasz

|||Thanks. I reset the account through the Reporting Services Configuration manager, and it works now.|||Hi Lukasz,

I have the exact same problem same error message but I'm not sure how to do step 2 that you mentioned.

Do you think you can maybe show me the steps to do that? I'm sorry if that seems a silly question. I haven't used reporting services before but I'm being thrown at the deep end. Much appreciated if you can help.

Regards,
YW
|||

Sure:

to open the tool, go to Start -> All Program -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration.

Select the instance you want to configure (local or remote).

On the database setup page, drop down "credentials type". Select a different type than what you have. Now Re-select the type you had originally. Now press the Apply button.

That should prompt you for database credentials and then you should see "granting database rights" or similar in the task list that shows up at the bottom of the window.

-Lukasz

|||Thanks HEAPS Lukasz !!!!
It worked....

No comments:

Post a Comment