x

SSRS subscription error

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'.
more ▼

asked May 29 '11 at 01:10 AM in Default

SqlAdv gravatar image

SqlAdv
274 9 11 13

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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
more ▼

answered May 29 '11 at 01:47 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x111

asked: May 29 '11 at 01:10 AM

Seen: 3103 times

Last Updated: May 29 '11 at 01:10 AM