Solved

SQL Server Reporting Services: Unable to Render a Report

Posted on 2009-05-18
6
592 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 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