Paul Galvin's (old) SharePoint space [SharePoint

Just another WordPress.com site

Adding to the Lore: SSRS Tells Me “rsAccessDenied”, But … I Really DO Have Access

A few weeks back, I was working with my developer colleague on a project involving SQL Server Reporting Services plug-in for MOSS.  He was developing a web part that provides a fancy front-end to the report proper (the main feature being a clever lookup on a parameter with several thousand searchable values behind it).

This was working great in the development environment but in the user acceptance testing (UAT) environment, it wouldn’t work.  Firing up the debugger, we would see exception details like this:

The permissions granted to user ‘UAT_domain\mosssvc’ are insufficient for performing this operation.(rsAccessDenied).

If you do a live search on the above error, you find it’s quite common.  Scarily common.  The worst kind of common because it has many different potential root causes and everyone’s suggested solution "feels" right.  We probably tried them all.

In our case, the problem was that we had done a backup/restore of DEV to UAT.  Somewhere in the data, something was still referring to "DEV_domain" (instead of the updated "UAT_Domain").  We created a new site, added the web part and that solved our problem.

Hopefully this will save someone an hour or two down the line.

</end>

Subscribe to my blog.

Technorati Tags:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: