[Troubleshooting] Install FIM Data Warehouse Support Scripts when the Data Warehouse SQL database resides on a Remote SQL Server
[Troubleshooting] Install FIM Data Warehouse Support Scripts when the Data Warehouse SQL database resides on a Remote SQL Server
https://social.technet.microsoft.com/wiki/contents/articles/17916.troubleshooting-install-fim-data-warehouse-support-scripts-when-the-data-warehouse-sql-database-resides-on-a-remote-sql-server.aspx
Comments
- Anonymous
September 25, 2013
Hi! One solution is to uninstall SQL Native client and then install SQL Server management Studio on Data Warehouse server and get invoke-sqlcmd cmdLet and run the following on DW Server: .FIMPostInstallScriptsForDataWarehouse.ps1 -DataWarehouseServerInstance localhost -DataWarehouseDatabaseServerInstance "sqlserverFQDNI03,57236" -FIMServiceAccountName "domainaccount"