I have an SSL device sending web traffic to an internal Sql2008 reporting service. This is all in an attempt to get TFS 2010 and WSS 3.0 all runing nicely together. So far, I've managed to get most things working except I'm having issues with the report service. Here's the problem. The SSL device is routing all traffic https://tfsportal.domain.com:443 -> http://machine:8001/ For Sharepoint, I was able to us AAM to deal with this. However, the ReportServer doesn't seem to have this ability. So what happens is this. You make a request like this. https://tfs.domain.com/ReportServer/params The result of this is a HTML page with an image tag. The src of the image tag is http://tfs.domain.com/xyz. I can't figure out a way to tell Reporting Service that the external tags it make should be https. I tried setting UrlRoot in rsreportserver.config, but that didn't help. At this point, I'm looking into using URL ReWrite Module 2.0 to edit the response to get it all working, but I can't help but think there's a better way.

Hi mark, Try to set the SecureConnectionLevel value to 0 like this <Add Key="SecureConnectionLevel" Value="0"/> in the rsreportserver.config file, then see whether this helps. thanks, Jerry

Hi mark, Try to set the SecureConnectionLevel value to 0 like this <Add Key="SecureConnectionLevel" Value="0"/> in the rsreportserver.config file, then see whether this helps. Open http://msdn.microsoft.com/en-us/library/aa179559(v=sql.80).aspx to read more details about SecureConnectionLevel setting. thanks, Jerry

I already had it set that way. The problem is that our load balancer is converting all https incoming requests to http requests, but for some reason, if the reporting services does a redirect or it includes URLs in it's response, these URLS are http even though I set the URLRoot param to https. WSS 3.0 addresses this through AAM. In one case I found an issue with WSS and was able to use the HTTP Rewrite Module for II7 to rectify it. If I could do the same for reporting services, I would be fine, but since reporting services 2008 no longer uses IIS, I can use the HTTP Rewrite Module. It's very frustrating. I was supposed to set up this machine in my "spare" time and it's a becoming a full time job. Hopefully someone can shed some light on the subject.