How to configure sql reporting services and iis through dmz
I am trying to setup an application on the dmz who will connect to a reporting services on the inside but I cant get the security to work.
This is how the configuration is:
One server on the DMZ running windows server 2003 in aworkgroup running IIS,ASP
One server on the LAN running windows server 2003 and sql2005 std with reporting services and the server is in a domain.
The web application is running on the DMZ server and I am trying to get a report through the application. I have tried with doing Impersonate in the application and supplied a domain account but it dosent work..If I open a browser on the dmz machine and type in the adress to the reporting server I get prompted for login and after supplying the domain account the report is generated ok but I cant get this to work through the application.
Any ideas how to configure the servers to get this to work?
/Jonas
