September 12, 2011 at 10:50 am
We have a lot of reports that we're converting to 2008 and I want to create one sql user to run them all. We are doing security in the dropdown so they can only see certain values in the dropdown.
I'm trying to find the best way to create one user I can use for all of my reports.
I tried going into sql mgmt studio, adding a user as guest in the main security tab, and adding a login under the specific database and giving it data read access. Well, that didn't work, so I gave it all access and the id is still failing when I try to use it in my data source. Is there a generic walk through of setting up an id for this purpose?
thanks!
M@
September 12, 2011 at 11:01 am
What is the error message you are receiving?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2011 at 11:03 am
An error has occurred during report processing. (rsProcessingAborted)
The permissions granted to user 'FACILITY\mtester' are insufficient for performing this operation. (rsAccessDenied)
The folder and the report gives Browser access to everyone.
When I run it, it's fine, because my windows creds have access to everything.
September 12, 2011 at 11:25 am
And that user has proc execute perms or datareader perms on the database that you are trying to connect to?
Assuming the report doesn't require writing data to the database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 12, 2011 at 11:34 am
No, he doesn't have access to the db at all,which is why I want to make the connection objects have a common user.
I've added a user called ssrsReportReader to the database security and given him guest access. then on the specific db, I've given him datareader, and when that didn't work, given him just about everything, and it still doesn't work.
September 12, 2011 at 11:42 am
Is FACILITY\mtester defined as the user in your datasource?
If that user is defined in the datasource - you have to grant it access to the db.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 16, 2011 at 11:21 am
No, the data source for the report is defined on the Report Server, and I checked the data source and the report, they run fine on the report server for me and for multiple people in my office.
The biggest difference here is that we're in one domain, and the test user is in another. I know he can at least get to the machine because I"m getting this error instead of the generic 'YouSuck' message that IE gives - believe me, that was the first problem 🙂
The only other thing I can think of is that it checks AD credentials in the dropdown of centers that drives the report. I"ll look there next.
September 16, 2011 at 12:22 pm
I didn't realize the report was using a shared dataset that the user didn't have access to.
September 16, 2011 at 12:44 pm
As you mentioned that the user is from different domain. Verify the user permissions to the other domain with network.May be that is causing the issue.
I had this issue myself and figured out that a specific permissions are needed when user is in different domain.
Thanks,
Swetha
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply