asked on

Permission problem with reports

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.

ASKER CERTIFIED SOLUTION

Fingo11

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Emes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TempDBA

ASKER

@Fingo11: No there are no nesting levels. All the domains are the main domain and all the users within that domain can access. We don't have problem with two domains but other 3 domains are throwing the error.

@Emes: They have right as the request to the procecedures and sql text is being run by a dedicated sql server login.

Emes

can you log into sql server using that use and run the sql?

based on what you said yes. but lets test it. most of the time this error is a sql rights issue.

you may be calling a function or something in the code that you do not have rights to.

TempDBA

ASKER

Got the problem solved. Though the user were added in the domain user, they were actually trying to connect through their local system which doesn't fall under the domain and that too without connecting through VPN. Silly mistake.