I am getting this error when I try to subscribe on ssrs integrated mode on sql 2008 r2. any idea? Thanks.An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
asked May 29 '11 at 01:10 AM in Default
Someone with a similar problem got it solved by following the details here: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/444c3bab-985b-40a0-8362-2742df1a6577/certainly your error message relates to a lack of permissions on the specified stored procedure, you may find following the details works for you but make sure you backup all you system before making changes and understand what you are going to be doing before you execute the queries
answered May 29 '11 at 01:47 AM