Wednesday, July 02, 2008

rsRPCError; The report server installation is not initialized

Reporting Services Error

The report server installation is not initialized

Check the link for more details


Also best practice to start with troubleshoot is to make sure remote SCOM server have full privilege on ReportsServer and ReportServerTempDB database.

After trying many options the one that work was to uninstall and reinstall Reporting Service. Below are the services

1. Uninstall Reporting service from Add and remove program. Select Microsoft SQL server and click Change button. Then select SQL => Reporting services

2. Reboot the box after uninstallation

3. Install Report Service from SQL 2005 setup.exe file and select only Reporting Services. Click Advance button and make sure the Path and Entire feature will be installed on local hard drive.

4. Install SQL SP2 if its not embaded in you previous setup.exe file.

5. Reboot SQL 2005 server box.

6. Configure "Reporting Service Configuration" under All Programs => Microsoft SQL Server 2005 => Configuration Tools.

No comments: