SQL Server Performance Forum – Threads Archive

Reporting services issue

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

---

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

---

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.

---

]]>