The permissions granted to user 'server\username' are insufficient for performing this operation. (rsAccessDenied)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » The permissions granted to user...

The permissions granted to user 'server\username' are insufficient for performing this operation. (rsAccessDenied)

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Grebey

Posted Wednesday, February 06, 2013 2:08 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:47 AM
Points: 30, Visits: 55

Trying to copy our Production Report Services over to a new machine. Really know almost nothing about it. Copied the DB over, configured the server, but when I try to hit the ReportServices URL I get the above error. How can I go about getting around this?

Post #1416728

anthony.green

Posted Thursday, February 07, 2013 1:38 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Can you detail the step by step process you performed?

Did you backup and restore the encryption keys?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1416869

Sean Grebey

Posted Thursday, February 07, 2013 7:29 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:47 AM
Points: 30, Visits: 55

anthony.green (2/7/2013)

Can you detail the step by step process you performed?

Did you backup and restore the encryption keys?

We had an existing ReportServices set up on one server that we needed to move off. Somebody had installed a version of ReportServices previously on the server we were moving to, so I backed up the SQL database and restored it over that existing install. I then deleted the encrypt key on the new machine, set it up with identical information as the old production machine (IPs changed but the aliases are the same). Backed up the new key, and then tried the links. The Report Manager URL works, so I went in there and added the account I was using in as a Role. But the Web Services URL gives me the above error about not having rights. I thought it might be a SQL permission issue, so I went into SQL and made sure it had full access to the ReportServices DB, but that didn't seem to help. This is my first time setting up RS though, so I must be missing something as I have no access to that URL.

Post #1417068

Sean Grebey

Posted Monday, February 11, 2013 10:04 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 9:47 AM
Points: 30, Visits: 55

Ok looking at the Event Viewer I see it is trying to use the anonymous IIS account from the web server to access the folder and doesn't have rights. Any thoughts on how to get around that?

Post #1418540

« Prev Topic | Next Topic »

Permissions