+ Reply to Thread
Results 1 to 10 of 10

Thread: Redirect SSRS URL

  1. #1
    Barn Newbie ChrisMahone is an unknown quantity at this point ChrisMahone's Avatar
    Join Date
    Jan 2010
    Posts
    3
    Rep Power
    3

    Redirect SSRS URL

    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

  2. #2
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    To redirect sites in IIS, see here: Microsoft Corporation
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  3. #3
    Barn Newbie ChrisMahone is an unknown quantity at this point ChrisMahone's Avatar
    Join Date
    Jan 2010
    Posts
    3
    Rep Power
    3

    SSRS doesnt use IIS. It relies on HTTP.SYS. Thats the problem!
    Thanks

  4. #4
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Are you able to create a default Html page on the server and use JavaScript (window.location) to redirect to the reports directory?
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


  5. #5
    Administrator richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich's Avatar
    Join Date
    Mar 2008
    Location
    Somewhere only we know...
    Posts
    3,207
    Blog Entries
    14
    Real Name
    Rich
    Rep Power
    14

    Do you have access to the DNS?

    I believe you could do a redirect using a DNS entry. I use a redirect so any requests to domain.com automatically redirect to www.domain.com. I wonder if you could try the same with a subdirectory?

    I have the following entry on my DNS
    Code:
    Host Name     Record Type            Address
        @         URL Redirect   http://www.domain.com
    
    I wonder if something like this would work for you
    Code:
    Host Name     Record Type            Address
        @         URL Redirect   http://www.domain.com/reports
    
    Don't know if that will help?

  6. #6
    Administrator richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich's Avatar
    Join Date
    Mar 2008
    Location
    Somewhere only we know...
    Posts
    3,207
    Blog Entries
    14
    Real Name
    Rich
    Rep Power
    14

    I just tried it on my DNS but it only redirected when I went to domain.com, not www.domain.com.

    Even when I removed the www and * records on my DNS.

    May be a cached DNS though, so could be worth a try.

  7. #7
    Barn Newbie ChrisMahone is an unknown quantity at this point ChrisMahone's Avatar
    Join Date
    Jan 2010
    Posts
    3
    Rep Power
    3

    Thanks guys, I tried both. I am still unable to redirect the page..still trying..

  8. #8
    I like Data Cubes too... Lauramc has a spectacular aura about Lauramc has a spectacular aura about Lauramc's Avatar
    Join Date
    Mar 2008
    Location
    Far Far Away
    Posts
    387
    Real Name
    Laura
    Rep Power
    5

    Just a guess, because I'm not at work, but is this set in the Reporting Services config file? Or perhaps the site setting on the Report Manager home page? I'd check there if you have not.
    "The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS

  9. #9
    Barn Newbie colinng is on a distinguished road colinng's Avatar
    Join Date
    May 2010
    Posts
    1
    Rep Power
    2

    SSRS 2008 URL Redirecting

    Here's an answer from a Microsoft forum moderator

    Damn it. "You are only allowed to post URLs once you have at least 5 posts."

    Add http:// to the link below.

    social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/86932bb5-a721-47ff-8ed0-1e144c87be4d

    Text included below

    -----

    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 - MSFT

  10. #10
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Thanks for sharing that with us

    Here's the clickable link: http://social.msdn.microsoft.com/For...0-1e144c87be4d
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.


+ Reply to Thread

Similar Threads

  1. SSRS Expressions
    By Wannabe in forum SQL Server Reporting Services Help
    Replies: 2
    Last Post: September 14th, 2009, 10:53 AM
  2. help with response.redirect line
    By Rebelle in forum ASP Development
    Replies: 3
    Last Post: August 10th, 2009, 11:41 AM
  3. redirect IF record exists
    By Centurion in forum ASP Development
    Replies: 6
    Last Post: June 4th, 2009, 08:48 AM
  4. Redirect Domain
    By Wolffy in forum Microsoft IIS
    Replies: 3
    Last Post: May 20th, 2009, 02:40 PM
  5. Backup SSRS Server
    By harish in forum SQL Server Reporting Services Help
    Replies: 4
    Last Post: May 6th, 2009, 06:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO