Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 HTTP.SYS and automatically redirecting to SSL

Author  Topic 

Des
Starting Member

7 Posts

Posted - 2008-09-11 : 10:38:15
Hi,

Does anyone know how to setup an automatic redirect from http to https within SQL 2008 RS?

--
Regards,

Desirée

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-11 : 11:38:24
Isn't that a job for IIS?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Des
Starting Member

7 Posts

Posted - 2008-09-11 : 11:47:34
I considered trying to do it in IIS, but I thought there may be a way to do it within the SSRS configuration utility or a change within the ReportServer.config file. The change from using IIS to using HTTP.SYS has been an adjustment to say the least. ;)

~Des
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-11 : 12:52:16
What do you want to redirect. A web page or what ?

As Peso said, its best to do it in IIS, as its very simple to implement it with your webserver.
Go to Top of Page

Des
Starting Member

7 Posts

Posted - 2008-09-11 : 13:05:55
I just want to automatically redirect http://servername/reports to https://servername/reports. By the way, I tried adding a website in IIS to do the redirect but I got an error.

"This binding is already being used by a product other than IIS. If you continue you might overwrite the existing certificate for this IP Address:Port combination. Do you want to use this binding anyway?"

This is due to the constraints within HTTP.SYS and IIS running side-by-side. Any ideas?

~Des
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-11 : 13:41:22
no
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-11 : 13:57:35
quote:
Originally posted by Des



"This binding is already being used by a product other than IIS.


... Any ideas?

~Des

If you were running IIS, it would be very simple to implement.
Go to Top of Page

Des
Starting Member

7 Posts

Posted - 2008-09-11 : 14:23:10
Trust me, I know. :) I figured it was better to use the new RS config tool to do everything because of HTTP.SYS. I will test out using the RS config tool as necessary, and try to do everything else with IIS. Has anyone else opted to use IIS instead of using the RS config tool for setting up RS 2008 within their environment? Any gotchas I should be aware of?
Go to Top of Page

davidshq
Posting Yak Master

119 Posts

Posted - 2009-11-20 : 16:30:38
Anyone ever figure this out? I'm trying to do the same.
Dave.
Go to Top of Page
   

- Advertisement -