+ Reply to Thread
Results 1 to 10 of 10

Thread: Redirect SSRS URL

  1. #1
    ChrisMahone
    ChrisMahone is offline
    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
    ChrisMahone, January 28th, 2010 03:08 AM
    Reply With Quote Reply With Quote
  2. #2
    jmurrayhead
    jmurrayhead is offline
    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, January 28th, 2010 09:15 AM
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
  3. #3
    ChrisMahone
    ChrisMahone is offline
    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
    ChrisMahone, January 29th, 2010 11:32 AM
    Reply With Quote Reply With Quote
  4. #4
    jmurrayhead
    jmurrayhead is offline
    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, January 29th, 2010 11:49 AM
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
  5. #5
    richyrich
    richyrich is offline
    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?
    richyrich, January 29th, 2010 11:56 AM
    Join the folding team
    Reply With Quote Reply With Quote
  6. #6
    richyrich
    richyrich is offline
    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.
    richyrich, January 29th, 2010 12:07 PM
    Join the folding team
    Reply With Quote Reply With Quote
  7. #7
    ChrisMahone
    ChrisMahone is offline
    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..
    ChrisMahone, January 29th, 2010 12:47 PM
    Reply With Quote Reply With Quote
  8. #8
    Lauramc
    Lauramc is offline
    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.
    Lauramc, February 15th, 2010 01:00 PM
    "The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS
    Reply With Quote Reply With Quote
  9. #9
    colinng
    colinng is offline
    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
    colinng, May 5th, 2010 10:10 PM
    Reply With Quote Reply With Quote
  10. #10
    jmurrayhead
    jmurrayhead is offline
    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, May 6th, 2010 08:11 AM
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


SEO by vBSEO