Wednesday, October 7, 2009

Unhandled Exception, Error while switching panels, SSRS, SQL Server 2005 Reporting Services

I tried to add reporting services today to my existing SQL Server 2005 instance on Windows 7. I installed it successfully however upon first run I faced an Unhandled Exception in WMI Component. Also when I clicked Server Status or any other option it said unable to switch panels WMI error again. Well upon googling it for a while I found nothing useful and thought to dig it myself. I came to the conclusion that there must be some difference between Service packs. I queried my server and found that I had installed SQL Server 2005 Service Pack 3 (SP3). However reporting service has just been installed and the SP3 wasn’t applied to it. Here is how I resolved:


Problem:

1. Error I faced upon first run of SSRS Configuration Manager





 
 
 
 
 
 
 
 
 
 
 
 


 
2. Second Error I faced when I clicked on the panel on left side




 
 
 
 
 
 
 
 
 
 
 
 
 


 
Resolution:
1. Download the relevant service pack you have already applied to SQL Server or most probably you already have it as you have installed it before.

2. In my case I had applied SP3 before I installed SSRS. You can download it here:

3. http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

4. You can download the versions for x86, x64 or IA64 versions depending upon you hardware and OS platform. I download this one SQLServer2005SP3-KB955706-x86-ENU

5. Once downloaded double click it and you will see the following screen:




 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


6. By default the checkboxes will be selected for whatever component the service pack wasn’t applied and in our case its Reporting Services
7. Hit Next




 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

8. Once the service pack is applied you would see the above screen hit Next again then the following screen























9. The last screen will be the following. You don’t need to apply windows vista provision tool at this stage since you must have already added your windows user to sysadmin group using this tool when you first installed SQL Server2005 on Vista or Windows 7. If not then do that too























Hope it Helps.

1 comment: