• If you have multiple instances of SQL Server, then you need a <ServerName> node that describes each instance. I am not sure the question makes this clear.

    If you use FineBuild to install your instances, then this work is done for you automatically.

    Also, if you install a SQL cluster and are certain you will only ever have one SQL instance on the cluster it is safe to setup SSIS as a cluster. If you want a SSIS cluster, use the parameter /SetupSSISCluster:Yes and FineBuild will build the SSIS cluster, setup a Package Store folder on a shared drive, and update MsDtsSrvr.ini to allow SSIS to recognise both the shared msdb database and the shared package store folder.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara