SSRS permissions error: report execution

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SSRS permissions error: report execution

Author

Topic

Maxer
Yak Posting Veteran

51 Posts

Posted - 2008-01-15 : 11:27:23

I am trying remove a report's execution schedule and I get this error in the report manager website:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Only members of sysadmin role are allowed to update or delete jobs owned by a different login.

This is the error I get in SSMS:
------------------------------

An internal error occurred on the report server. See the error log for more details. (rsInternalError) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00

------------------------------
ADDITIONAL INFORMATION:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) (ReportingServicesLibrary)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00

------------------------------

Only members of sysadmin role are allowed to update or delete jobs owned by a different login. () (.Net SqlClient Data Provider)

------------------------------
BUTTONS:

OK
------------------------------

However I AM the systems administrator.

This is a dev server and I restored a backup from production to this server so I think that may be part of the issue.

However, I am unable to locate any details on which user account it thinks lacks these permissions. I am logged in as the administrator local to the machine and sys admin of the SQL database server.

Suggestions?

EDIT: Could it be an issue with the Network Service account? I have that listed as the account in the IIS app pool that report server is using.

Since that was setup on my production server then moved to my dev server, could that be an issue as it is a LOCAL account not a domain account?

Maybe it doesn't have proper access?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources