Need to access Reporting Services from outside firewall. The IT department installed second instance of RS on a box outside the firewall and pointed it to the Report Server inside the firewall. The application that runs the reports uses Forms Authentication
and appears to working correctly. It picks up the "cookie" from RS and calls the report with the cookie in the header.
The call to programmatically login to RS works...but when the report is requested, a page comes up and asks the user to enter the username and password for the "data source". Once a "sql server user" is entered, and the user clicks on the "View Report"
button, the report comes up. Why is RS asking for credentials for the report's data source???
View Complete Post