Background

 

 

If one or more of the following conditions exist, you can use the procedure in this topic to repair the SSRS managed performance counters.

  • The following performance counter groups are missing
    • MSRS 2008 R2 Windows Service
    • MSRS 2008 R2 Web Service

  

     

  • Performance counters under one of the groups noted above are not accessible.
  • The Windows application event log contains error similar ”The report server cannot create the [name of a counter] performance counter".


Work Around

To work around this issue you can re-build the performance counters. You need to have administrative permissions on the computer to rebuild the performance counters.

To repair the performance counters

  • Verify the directory where the Microsoft .NET Framework version is installed.  For example “C:\Windows\Microsoft.NET\Framework\v4.0.30319”.
  • Open a command prompt with administrator privileges. “Runs as administrator”.
  • Run the following command to change the path environment variable to the directory where the Microsoft .NET Framework version is installed. The new path is temporary and the scope of the path change is local to the command prompt session.

 path=C:\Windows\Microsoft.NET\Framework\v4.0.30319

  • Run the following command to change the directory to the directory that contains the file ReportingServicesLibrary.dll. By default the path is the following:

CD C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin

  • Run the following command from the command prompt to uninstall the report server resources:

installutil.exe /u ReportingServicesLibrary.dll

  • Run the following command from the command prompt to re-install the report server resources:

installutil.exe ReportingServicesLibrary.dll

 



More Information

  • If running the commands fails with the error:

Attempted to read or write protected memory. This is often an indication that other memory has been corrupted."

And if the operating system, is Windows Vista (RTM or SP1) or Windows Server 2008 (RTM or SP1), then install the following Operating system hotfix:

An application may crash when it uses legacy methods to query performance counter values in Windows Vista or in Windows Server 2008

  • If the execution failed with the error, "Input string was not in a correct format". You need to rebuild the performance counter library values.  For more information, see:
How to manually rebuild Performance Counter Library values and Event ID 61, Windows Operating System

 


Applies to

       Microsoft SQL Server 2008 R2 Reporting Services.

See Also