Solved

SQL Server Reporting Services: Unable to Render a Report

Posted on 2009-05-18
6
584 Views
Last Modified: 2012-05-07
I'm trying to render a report in a C# Web Page.  The reporting server is on a different server.  I'm having trouble with the ExecutePermissions.  When I set the permissions using a specific username, password - access is granted and the report renders:

output.ReportExecutionCredentials = (System.Net.ICredentials)new System.Net.NetworkCredential("lusername", "password", "domain");
        //output.ReportExecutionCredentials = (System.Net.ICredentials)System.Net.CredentialCache.DefaultCredentials;

However - I don't have the user's passwords and need to be able to set this dynmcially.  When I try:

output.ReportExecutionCredentials = (System.Net.ICredentials)System.Net.CredentialCache.DefaultCredentials;

the DefaultCredentinals come back as empty and I keep receiving "access denied."  How can I set this without using a username and password so every user on my website can render these reports?

any help would be much appreciated!
       
0
Comment
Question by:coecho
  • 2
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Emes
Comment Utility
Use windows authentication using the web user.

and then gran exec permissions on the needed stored procs.


0
 

Author Comment

by:coecho
Comment Utility
I don't understand what you mean by the "Web User".  The user is alredy signing on using Windows Authentication.  Are you saying to grant execute permissions on the stored procedures for every single individual signing on?  Can you provide a C# code example of what you're describing?  thanks.
0
 
LVL 14

Accepted Solution

by:
Emes earned 250 total points
Comment Utility
I have not done this in a long time I will try to show you.

need to go to the IIS configuration and get the anonymous  id.

That is the Id that you will need to set in sql server to have access to the procs.

 


reh.bmp
0
 

Author Comment

by:coecho
Comment Utility
What if I don't want to allow "anonymous user" access on IIS?  I have it set now to just use Windows Integrated Security.  Is there a way in C# code to allow access?
0
 
LVL 7

Assisted Solution

by:60MXG
60MXG earned 250 total points
Comment Utility
You can create a User Group in the domain then add all those users into the group.  In your SQL Server you grant this particular group with access to the database.  

For an example, you create a user group called SQLReportUsers in the Domain Server.  You have User A, User B need to access the database then You add all User A and User B into SQLReportUsers group.  In your SQL Server you grant access to SQLReportUsers group.  I think that will fix your security issues.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

How to increase the row limit in Jasper Server.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now