Monday, October 25, 2010

Reporting services failed to start after upgrading to SQL 2008 R2

I recently upgraded my x64 version SQL 2008 to SQL 2008 R2. After everything completed without error, the Reporting services failed to start. There are two exceptions in the Reporting Service log related to performance counter.

Error creating counter.  Category: MSRS 2008 R2 Windows Service, Counter: Report Requests, Instance: MSSQLSERVER.  Error Description: System.InvalidOperationException: The requested Performance Counter is not a custom counter, it has to be initialized as ReadOnly.

ERROR: Appdomain:1 DefaultDomain failed to initialize. Error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Diagnostics.SharedPerformanceCounter.GetCategoryData()

After I tried to repair it, the following error has occurred:



The file does not exist on the DVD at all.

Since I could not figure out any solution and unable to repair it, I then uninstalled and re-installed the SSRS component. After that, the Reporting Services started successfully.  

I searched the internet and found the following post related to the repair bug:

The workaround is to copy the setup files to a shared or local dir, and rename the \\1033_ENU_LP\x64\Setup\SSCERuntime.msi to SSCERuntimr_x86-enu.msi. Now, the pair runs successfully.

No comments:

Post a Comment