SQL Server Performance

SSRS 2000 not working properly

Discussion in 'SQL Server Reporting Services' started by Akthar, Jul 18, 2007.

  1. Akthar New Member

    Guys,
    i received everyday error when accessing my Reporting Services report manager .
    I have to restart IIS to corret the error.

    Any clue?

    AKTHAR
  2. dineshasanka Moderator

    What is the error you are getting

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. Akthar New Member

    only getting "page cannot be displayed"

    AKTHAR
  4. dineshasanka Moderator

    This is maily due to IIS error,
    Verify whether IIS started at the time you are gettign the error.

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  5. Akthar New Member

    Yes the IIS service is started. If i restart the service, then the report manager works fine. But i get this error almost everyday and i have to restart the IIs service

    AKTHAR
  6. Akthar New Member

    exact error message:
    "Server Application unavailable"
    "the web application you are attempting to access on this web server is currently unavailable. Please hit refresh button in your browser to retry your request"

    any advice



    AKTHAR
  7. satya Moderator

    Do you have any issues with .NET framework on this server, I presume your report server was installed under the default website.
    If so then try to access your report manager using this link:

    http://localhost:80/reports


    If this does not work and you do not think that changing the port on where the web is installed will impact any websites for your reports to deply, try changing the port for companyweb to a different unused port.


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  8. elracorey New Member

    I'm using SQL Server 2005 but had the same issue.
    When you install SQL Server you get the choice of default install or an INSTANCE install. For example my instance is localhostSQL2005.
    You get a database name of ReportServer $2005 but it seems to work ok.

Share This Page