Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 722
  • Last Modified:

SQL 2008 R2 report services error

I'm getting the following error on the report server after moving the database to anew server.
is there a way to update the system to give permission?



An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)

The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
0
atorex
Asked:
atorex
  • 2
1 Solution
 
RimvisCommented:
Hi  atorex,

This might help:

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

http://history.sqlserver-qa.net/blogs/bi/archive/2008/05/27/execute-permission-denied-on-object-xp-sqlagent-notify-database-mssqlsystemresource-schema-sys.aspx
0
 
sammySeltzerCommented:
There is a user called xp_sqlagent_notify.

Expand the database, right-click on Properties,
Click on Permissions.

Select  xp_sqlagent_notify

Scroll down till you see Execute. Check the box and this should fix the problem you are having right now.
0
 
atorexAuthor Commented:
I dont have xp_sqlagent_notify or perhaps cant find it, I have couple local users only one is a reportuser
0
 
sammySeltzerCommented:
Ok, then this link has same problem as you and suggested solution resolved.

http://www.sqlservercentral.com/Forums/Topic452669-150-1.aspx

Hope it resolves yours.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now