/> </CodeGroup> 5. Save the changes and the XML editor. To add an Extension tag to the Data segment in the rsreportserver.conf file 1. On the computer hosting SSRS, locate the file rsreportserver.config in the following folder: a. For SQL Server 2008 SP1, locate \Program SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer. b. For SQL Server 2008 R2, locate \Program SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. 2. Using an XML editor of your choice (such as Notepad), open the rsreportserver.config file. 3. Scroll through the rsreportserver.config file and locate the <Data> code segment. is only one <Data> code segment in this file. 4. Add the following Extension tag to the <Data> code segment where all the other Extension tags are: <Extension Name="SCDWMultiMartDataProcessor" Microsoft.EnterpriseManagement.Reporting.Code" /> 5. Save the changes and the XML editor. Manual Steps to Prepare Upgraded SQL Server 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 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.
/> </CodeGroup> 5. Save the changes and the XML editor. To add an Extension tag to the Data segment in the rsreportserver.conf file 1. On the computer hosting SSRS, locate the file rsreportserver.config in the following folder: a. For SQL Server 2008 SP1, locate \Program SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer. b. For SQL Server 2008 R2, locate \Program SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer. 2. Using an XML editor of your choice (such as Notepad), open the rsreportserver.config file. 3. Scroll through the rsreportserver.config file and locate the <Data> code segment. is only one <Data> code segment in this file. 4. Add the following Extension tag to the <Data> code segment where all the other Extension tags are: <Extension Name="SCDWMultiMartDataProcessor" Microsoft.EnterpriseManagement.Reporting.Code" /> 5. Save the changes and the XML editor. Manual Steps to Prepare Upgraded SQL Server 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 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.
SC2012_ServiceMgr_Deployment.docx