Install FIM Data Warehouse Support Scripts when the Data Warehouse SQL database resides on a Remote SQL Server.
Issue:
Currently the FIM Reporting documentation for the installation of Service Manager Data Warehouse server with its SQL database on a remote SQL server does not describe how to install the FIM post installation scripts. The installation of such configuration requires additional steps.
Scope if this document:
The scope of this document is the step-by-step workaround to install the FIM Reporting Post installation scripts when the Data warehouse database is on a remote SQL server. Keep in mind that another "most do" procedure required by the Service Manager Data Warehouse installation to use SSRS is needed. This procedure is outside the scope of the document. See details below if you need help with SSRS.
---
Manual Steps to Configure the Remote SQL Server Reporting Services(SSRS)
Describes how to manually configure SQL Server Reporting Services (SSRS) in situations where SSRS is not on the same server as the data warehouse management server.
http://technet.microsoft.com/en-us/library/ff460955.aspx
Overview:
The FIM Reporting post installation scripts required to execute .\FIMPostInstallScriptsForDataWarehouse.ps1 scripts in the Data Warehouse server. However, this script requires access to the "SQLCmd" tools and the "SMCmdletSnapIn" snapins. These two components are both present when the SLQ server resides in the Data Warehouse server. In this scenario that condition is not true. In this procedure, we will run the FIM post installation powershell script in the SQL server. We will create a PSSessionConfiguration in the Data Warehouse server that will get called from the remote SQL server to execute the "SMCmdletSnapIn".
Steps:
Close Windows PowerShell.
Richard Mueller edited Original. Comment: Modified title casing, added tags