Wednesday, May 9, 2007

Reporting Service installation problem

When you install SCOM 2007 Reporting Service, you need to install .net 3.0. In my case, .net 2.0 was installed first and .net 3.0 after. When installing the SQL 2005 reporintg services I get an error that saying it cannot connect to the Reporting Services. After investigation, the Reporting service must write to the directory:

A good way to know if your reporting service is working before installing SCOM Reporting is to connect to your Reporting server using the following URL:

http://localhost/Reports/Pages/Folder.aspx

This should bring a screen like the following



If you get this screen, your Reporting Service is working fine.

The report server cannot decrypt the symmetric key

When installing SCOM 2007, you may encounter a problem with the Reporting service and the symentric key decryption. This sometimes happen when you change the service account of the Reporting Services. To fix the issue, you can use this KB from Microsoft. The article applies to SQL 2000 but also work in my case with MS SQL 2005.