SQL Server Performance

Reporting services issue

Discussion in 'SQL Server 2005 Reporting Services' started by amara, Jun 11, 2007.

  1. amara Member

    We have been facing an error with respect to reporting services configuration in sql server 2005
    All the settings in the reporting services configration manager are fine, but we are not able to open the reports page- http:localhost/reports
    The login account that we are trying to start/stop reporting services also has the domain admin rights
    The same setup is working fine on the test setup but is not working on the production setup
    we are getting the below error in the apllication logs:
    "Report Server Windows Service (MSSQLSERVER) has not been granted access to the catalog content."
    Please help me to sort this issue

  2. satya Moderator

    Please post the question in relevant section only, moved from General DBA section.

    You need run reporting services configuration to point RS to new sql server, to resolve this issue.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.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.
  3. amara Member

    quote:Originally posted by satya

    Please post the question in relevant section only, moved from General DBA section.

    You need run reporting services configuration to point RS to new sql server, to resolve this issue.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.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.

    Sathya, could you please elaborate the solution
  4. satya Moderator

    Bring up the reporting services configuration tool to point out the correct RS server in this case,http://technet.microsoft.com/en-us/sqlserver/bb331776.aspx andhttp://blogs.msdn.com/sharepoint/ar...s-integration-with-wss-3-0-and-moss-2007.aspx will give you more information in addition to books online.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.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.

Share This Page