I receive the following error when I try to save a subscription after configuring it. I appreciate any insight that anyone has.
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