# Connecting SailPoint Multi-Host with Microsoft SQL Server ## Adding a New Multi-Host Source in SailPoint To add a Multi-Host source in SailPoint, perform the following tasks: 1. Go to **Admin \> Connections \> Multi-Host Sources**. 2. Select **Create New**. 3. Enter the **Multi-Host Name** of the group of sources that you are setting up. 4. Enter the **Multi-Host Description** of the source. Ensure that the name and description of your source are unique. This description will help you identify the associated sources and tasks associated with a multi-host source. 5. From the **Integration Type** dropdown list, select a source type. 6. Enter the name of the **Integration Owner** of the multi-host source or select one. > **Note** > > You must select an **Integration Owner** at this time. 7. Select the **Virtual Appliance Cluster** that you want to assign for your integration. > **Important** > > Once a Virtual Appliance Cluster is selected and saved, it cannot be updated later. 8. (Optional) Select **Use a Credential Provider**, if you have a credential provider configured in your tenant and want to use it. 9. (Optional) Select the appropriate **Governance Group** for source management from the dropdown list. For more information about governance groups, refer to [Associating Governance Groups with a Source](). 10. Select **Create** to create a source with your selections. ## Base Configuration Provide the base configuration parameters. Information you entered in the **Create New** dialog is automatically entered into the fields in the base configuration page. You can edit this information if necessary. > [!NOTE] > > **Screenshot** > > [![Base Configuration]()]() > [!NOTE] > > Ensure that the name and description of each source is unique. 1. Enter the **Multi-Host Name** of the group of sources that you are setting up. 2. Enter the **Multi-Host Description** of the integration. Ensure that the name and description of your integration are unique. This description will help you identify the associated sources and tasks associated with an integration. 3. From the **Integration Type** dropdown list, select a source type. 4. Enter the name of the **Integration Owner** of the Multi-Host source or select one. > **Note** > > You must select an Integration Owner at this time, while creating the Multi-Host. 5. Select the **Virtual Appliance Cluster** that you want to assign for your integration. > **Important** > > Once a Virtual Appliance Cluster is selected and saved, it cannot be updated later. 6. (Optional) Select **Use a Credential Provider**. 7. (Optional) Select the appropriate **Governance Group for Source Management** from the dropdown list. For more information about governance groups, refer to [Associating Governance Groups with a Source]() on the SailPoint Compass site. 8. Upload files that are essential for your Microsoft SQL Server configuration. For example, a JAR file must be uploaded for a Microsoft SQL Server source to configure correctly. > **Note** > > The files that are unsupported and those exceeding the size limits will not be saved to the configuration. 9. Select **Continue**. ## Bulk Upload Settings > [!NOTE] > > **Screenshot** > > [![Bulk Upload Settings]()]() 1. Select **Bulk Upload** to upload your CSV file with all of the sources. Each source name should be unique in the CSV file. > **Warning** > > Do not provide any sensitive data in the CSV file. For example, password. 2. Select **Continue**. ## File Upload > [!NOTE] > > **Screenshot** > > [![File Upload]()]() 1. Select the CSV file containing metadata required to create the Microsoft SQL Server sources. Refer to the [CSV template]() provided by SailPoint. > **Note** > > Each source name should be unique in the CSV file. > > The only supported authentication types (`authType`) are `SQLAuthentication` and `WindowsAuthentication`. 2. Select **Continue**. The Multi-Host source starts creating the Microsoft SQL Server sources for the uploaded data. After saving it, it redirects you to the Multi-Host landing page. From here you can select your configured Multi-Host source, select **Edit**, and then manage the individual sources. This includes account and entitlement aggregation. For more information, refer to [Managing Multi-Host Groups](). ## Authentication Settings Provide the following information required to connect and interact with the Microsoft SQL Server sources. > [!NOTE] > > Authentication is not required. If you select one of the following authentication types, it will override already configured credentials on the connected server sources. > [!NOTE] > > **Screenshot** > > [![Authentication Settings]()]() 1. Select an **Authentication Type** for the service account of the Microsoft SQL Server sources. - **SQL Authentication**: Select SQL Authentication for all the sources you want to configure with similar credentials. - **Windows Authentication**: Select Windows Authentication for all the sources you want to configure with Windows authentication. 2. Enter the **Username** of the selected authentication type to manage the source. 3. Enter the **Password** to authenticate with the Microsoft SQL Server source. 4. Select **Continue**. The Multi-Host source starts updating the Authentication Settings for the Microsoft SQL Server sources. After saving it, it redirects you to the Multi-Host landing page. From here you can select your configured Multi-Host source, select **Edit**, and then manage the individual sources. This includes account and entitlement aggregation. For more information, refer to [Managing Multi-Host Groups]().