INSTALLING THE SCOM REPORTING
Sorry folks for the delay in posting this!!!
The reason for setting up the reporting separately is to easily isolate errors if any.
Launch the SCOM setup and select “Add a feature”
Next select “Reporting server”
Here we have taken care of all the pre-requisites. If you face any error in this step kindly post it here, we will take a look in to it.
These are a few things you can check if something goes wrong,
1. Check if the SQL server is listening on the configured port. By default this is 1433. If you use another port you should specify this during the SCOM installation. You can test this with telnet. (install the telnet client on a Windows 2008 box) Use this command: telnet 1433
2. Make sure you are doing the installation for reporting on the SQL server and not on the SCOM server! This is a common mistake.
3. Test if the reporting services are installed.
In the next screen you should be prompted with your SQL server instance that you are going to use for setting up your SCOM reporting. In my case I have installed it on a named instance SCOM. Hence it will be “servername\instancename”. In case of default instances, it will come as “servername”
If this does not show up here, kindly check the pre-requisites or let us know.
Once this validates, just enter the Data Reader account.
It is done !!!!!!!!