Problem with accessing reports

Question

Problem with accessing reports

dreamthebest

Ten Centuries

Points: 1324
More actions
December 24, 2010 at 3:47 am

#232292

Hi,
We have reports which are running fine at our place. When the same reports were tried by users from other location with other domain they are shown error. The error message is as:
"The permissions granted to user XYZ\UserName are insufficient for performing this operation".
The domainusergroup xyz is included in the security setting for the reports with the role provided as browser.
Can someone help with this.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

Any chance that the the dataset credentials are set to use integrated security and the users from the XYZ domain don't have appropriate rights to that datasource?

To help us help you read this[/url]For better help with performance problems please read this[/url]

dreamthebest Ten Centuries Points: 1324 More actions · Answer 2

Thanks for your response.

We are not using integrated security option. We are instead using a SQL server login to connect and run the reports. So, there shouldn't be a problem.

The domain users from other location are able to access other applications from this domain except reports.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

At what point do they see the access denied message? When they try to load the report or when they try to run it?

Also, you may be having some issues with cross domain access rights. You might try creating a group local to the domain which has your SSRS server in it then adding the group from the XYZ domain to that group ( Or perhaps even adding a user or two from the XYZ domain directly into the domain local group). It's the old school way of doing trusts and such that AD was supposed to be able to do away with, but might be just the ticket for your environment.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]