Solved

SQL Server Reporting Services: Unable to Render a Report

Posted on 2009-05-18
6
588 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
ID: 24415545
Use windows authentication using the web user.

and then gran exec permissions on the needed stored procs.


0
 

Author Comment

by:coecho
ID: 24415664
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
ID: 24415797
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
ID: 24416424
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
ID: 24435532
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

815 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

12 Experts available now in Live!

Get 1:1 Help Now