SSRS 2008 - click on URL - page not found

  • I installed a named instance of Sql Server 2008. When I go to "Reporting Services Configuration manager" and click on "Report Manager URL" it displays a URL link on the right side of the page:

    http:// :80/Reports_Jerry2008

    When I click the link I get "Page not found" in the browser.

    I read that you have to specify port 80 when using IIS 5.1 with XP pro.

    I think I also read that 2008 doesn't use IIS the way 2005 did for reporting services.

    Thanks in advance for the help.

    Jerry

  • What OS are you running? XP?

    SSRS 2008 does not need IIS like SSRS 2005 do, it will have its own web host process

    Your URL is clearly not complete

    Did you use the "Reporting Service Configuration Manager" in the programs menu?

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • What OS are you running? XP?

    XP Professional SP3

    SSRS 2008 does not need IIS like SSRS 2005 do, it will have its own web host process

    As I mentioned I had read that but I still need IIS for web development.

    Your URL is clearly not complete

    The URL should have read http://MachineName:80/Reports_Jerry2008

    Did you use the "Reporting Service Configuration Manager" in the programs menu?

    Yes. .... Start ... All Programs ... Microsoft Sql Server 2008 ... Configuration Tools ... Reporting Services Configuration Manager.

  • Thanks for the info

    can you connect successfully to the MachineName in SSRS Config Manager? did the status say "Started" or "Stopped"?

    It's also possible you need a different port between default IIS (80) and a new one for SSRS

    unless SSRS installer added the ReportServer application pool under IIS

    I have SSRS installed on my laptop, no IIS installed, worked fine

    on our SSRS server, I can specify the TCP Port, Virtual Directory name, and it shows a URL at the bottom for you to click

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • Thanks for the info

    can you connect successfully to the MachineName in SSRS Config Manager? did the status say "Started" or "Stopped"?

    It's also possible you need a different port between default IIS (80) and a new one for SSRS

    unless SSRS installer added the ReportServer application pool under IIS

    I have SSRS installed on my laptop, no IIS installed, worked fine

    on our SSRS server, I can specify the TCP Port, Virtual Directory name, and it shows a URL at the bottom for you to click

    Thanks for the reply.

    Yes, I can successfully connect to the machine name. It said "Started"

    Not sure on the different port. What would it be?

    It showed the the same URL under "Web Service URL" and "Report Manager URL"

  • My SSRS port says 80 (default), but that MAY conflict with your IIS if it's on port 80 already

    Try giving it a different port (81, 8080), and re-start the SSRS and try again

    I suppose you can check the TCP ports running

    http://live.sysinternals.com/Tcpview.exe

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • I changed it to port 81 and got this:

    Reporting Services Error

    --------------------------------------------------------------------------------

    The report server has encountered a configuration error. (rsServerConfigurationError) Get Online Help

    --------------------------------------------------------------------------------

    SQL Server Reporting Services

    At least that's different.

  • I found the answer to my problem:

    https://www.blogger.com/comment.g?blogID=6855339694180792214&postID=3752127317600592384&page=1

    SS2008 installation requires you to create a Report Server DB or access an existing one. In 2005 I'm pretty sure it did it automatically.

  • Also I did have to use port 81.

    Won't work on port 80.

  • higgins.jerry (3/24/2009)


    I found the answer to my problem:

    https://www.blogger.com/comment.g?blogID=6855339694180792214&postID=3752127317600592384&page=1

    SS2008 installation requires you to create a Report Server DB or access an existing one. In 2005 I'm pretty sure it did it automatically.

    Very certain SSRS 2008 install CAN create the ReportServer and ReportServerTempDB for you, that's how I did mine because I did not have any current SSRS2008 databases to copy over

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • For those who stumble on this same problem wirth SSRS R2, I also found my solution in this thread. When I installed SQL 2008 R2 Enterprise Edition, I used the default configuration option. On the W7 box, the installation worked just fine out of the box. On XP Pro Sp3, I had the same problem as described in this thread.

    I opened Report Services Configuration Manager

    Navigated to Web service URL

    Changed the default TCP Port from 80 to 81

    Clicked Apply

    Navigate to Report Manager URL

    Clicked Advanced

    Removed Port 80

    Added Port 81

    Clicked OK

    Clicked Apply

    Test the URL

    Now I had some slowness when trying to opne the web server and report manager URL's. I opened the port (81) on the firewall and all slowness went away.

    My question to the community is, "Would opening the port on the firewall increase my performance?"

  • Hi,

    Reporting Services configuration manager can assist you in creating the reportserver abd reportservertempdb databases for you.

    the requirements for this are as follow. A sql server instance where you can host the databases and the account that you used for reporting services needs DBcreator nd dbowner rights on that instance.

    once you have the above ready, you can go to the configure database section and choose create database for reporting services option and follow the config manager. once complete your reporting databases should be available.

    hope this helps.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply