troubleshooting Question

Report Server credentials

Avatar of QPR
QPRFlag for New Zealand asked on
Microsoft SQL Server
5 Comments1 Solution680 ViewsLast Modified:
I have a whole list of reports that I've been asked to publish to a wider audience.
We don't want to add these users (windows authentication) to the list of database users so I have set the reports datasource to use a specific username/password.
This account has all the necessary permissions in the database. All worked fine for me.
Then I deployed the new datasource and asked a user to test. They get connection errors.

I set up a profiler trace to see what was happening at the database level.
I open the report, select parameters and view the report.

The parameters are based on a query - one drop down box populates a second based on user selection.
Although the report itself is being run under the security context of the specific account the query that populates the second drop down box is run under the logged on users (windows) account.
Any ideas?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros