Manual Steps to Prepare Upgraded SQL Server

 

Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager

If you upgrade SQL Server 2008 R2 to SQL 2012 after Service Manager SP1 installation, you must manually copy the Microsoft.EnterpriseManagement.Reporting.Code.dll file in order for SQL Server Reporting Services (SSRS) to function properly.

To copy the Microsoft.EnterpriseManagement.Reporting.Code.dll file

  1. On the computer that is hosting SSRS, open an instance of Windows Explorer.

  2. Open <InstallationDrive>:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin and copy the Microsoft.EnterpriseManagement.Reporting.Code.dll file from the Prerequisites folder on your Service Manager installation media folder.