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, 2011 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, 2011 at 01:47 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(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.

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:

x113

asked: May 29, 2011 at 01:10 AM

Seen: 3641 times

Last Updated: May 29, 2011 at 01:10 AM