SQL Server Reporting Services: Unable to Render a Report
Posted on 2009-05-18
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!