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
On the computer that is hosting SSRS, open an instance of Windows Explorer.
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.