Answered SSRS 2008 URL Redirecting

  • Thursday, January 28, 2010 6:46 AM
     
     
    I have SSRS installed on a machine having SQL Server 2008. My reports are hosted on "www.mywebsite.com/reports"
    Is there a way I can redirect people entering site URL "www.mywebsite.com" directly to "www.mywebsite.com/reports" so that they can directly see the reports site?
    If it can be done please suggest how its done.
    Thanks
    Regards
    Chris

Answers

  • Friday, January 29, 2010 10:46 AM
    Moderator
     
     Answered
    Hi Chris,

    Since SQL Server Reporting Services 2008 is independent of Internet Information Server(IIS), we are not able to redirect 'www.mywebsite.com' to 'www.mywebsite.com/reports' by default.

    However, we can use this workaround to to solve the issue:
    1.Install IIS on the report server. create a website with 80 port.
    2.In this site, create a HTML web page with the following code:

    <script>window.location = 'http://www.mywebsite.com/reports</script>

    3.Save the file to be Default.Html. This file to used to redirect the user to the report manager on the file loading.

    Now, we are able to redirect the user to 'www.mywebsite.com/reports' while the user accessing 'www.mywebsite.com'

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen
    Jin Chen - MSFT

All Replies

  • Friday, January 29, 2010 10:46 AM
    Moderator
     
     Answered
    Hi Chris,

    Since SQL Server Reporting Services 2008 is independent of Internet Information Server(IIS), we are not able to redirect 'www.mywebsite.com' to 'www.mywebsite.com/reports' by default.

    However, we can use this workaround to to solve the issue:
    1.Install IIS on the report server. create a website with 80 port.
    2.In this site, create a HTML web page with the following code:

    <script>window.location = 'http://www.mywebsite.com/reports</script>

    3.Save the file to be Default.Html. This file to used to redirect the user to the report manager on the file loading.

    Now, we are able to redirect the user to 'www.mywebsite.com/reports' while the user accessing 'www.mywebsite.com'

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen
    Jin Chen - MSFT
  • Tuesday, October 11, 2011 12:16 AM
     
     
    A redirect from the root to "Reports" folder should be a setting in SSRS.