Link to home
Start Free TrialLog in
Avatar of Kpt12
Kpt12

asked on

SSRS 2008 R2 - How to redirect URL from http to https ,when IIS not installed.

SQL Server 2008 R2 does not required IIS to install on server. We have not installed IIS on the system. In this case, How to redirect Report Manager URL from  http to https without IIS.  
My Settings:
In Reporting Service configuration tool, under Report Manager URL I just added https://rs.abc.com/Reports   (not added any http url)

so when I tried to access http url it should redirect to https above url. How can I solve this problem?

Environment:
Windows Server 2003 R2 64bit with SQL Server 2008 R2 64bit

Thanks

Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

If you only allow SSL and you only provide users with the https: URL then there should be no need to redirect. Are you saying that the (direct) https: URL doesn't work?

Are the users accessing the URL via intranet or Internet? If intranet, have you tried using just the server machine name for the hostname in the URL, rather than the fully-qualified domain name (FQDN)? i.e. https://rshost/Reports instead of https:/rs.abc.com/Reports

If this is intranet-only and the short name works and you really need to have the FQDN work as well then you will need to do some additional configuration. If you are trying to go over the Internet directly using WIndows Authentication then that is a different set of issues with which I am not familiar (and not something I would recommend).
Avatar of Kpt12
Kpt12

ASKER

Hi rscowden,
Thank you for the reply. Yes I want to use within Intranet not on the internet. Well, I am using Windows Integrated security with domain user. I do not want to use server name direct so I am using FQDN. http and https both url s are working fine.

 when user types Report Manager URL  with http i.e. http:/rs.abc.com/Reports then it should be redirected automatically to https i.e.  https:/rs.abc.com/Reports page to use SSL. How can I do this ?
Thanks
Other people have asked for a way to do this, but I have not come across any published code so far. I do something similar in my own web apps that might work with RS, by adding a module via the RS web.config file. I don't know if my code would work with Windows Server 2003 but it should--I think it just needs .NET Framework 2.0. If you aren't in a hurry and if nobody else has a solution, I might be able to come up with something.
Avatar of Kpt12

ASKER

Hi rscowden,

Thanks for the reply. I am not in a hurry. I would be happy.

Thanks again.
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kpt12

ASKER

Hi rscowden,

This is greate. I will test it soon.  i really appreciate your help.

Thanks.
Avatar of Mike McCracken
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.