[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

  • Comments 1

[Troubleshooting] Install FIM Data Warehouse Support Scripts when the Data Warehouse SQL database resides on a Remote SQL Server
http://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

Leave a Comment
  • Please add 4 and 8 and type the answer here:
  • Post
  • 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 "sqlserverFQDN\I03,57236" -FIMServiceAccountName "domain\account"

Page 1 of 1 (1 items)