asked on

SQL Server Reporting Services: Unable to Render a Report

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!

Emes

Use windows authentication using the web user.

and then gran exec permissions on the needed stored procs.

coecho

ASKER

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.

ASKER CERTIFIED SOLUTION

Emes

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

coecho

ASKER

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?

SOLUTION

60MXG

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial