# SailPoint Multi-Host with Microsoft SQL Server Connector Documentation > Multi-Host with Microsoft SQL Server Connector Documentation # Documentation # 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](). # Integrating SailPoint Multi-Host with Microsoft SQL Server The SailPoint Multi-Host solution for Microsoft SQL Server provides you the ability to create and manage groups of Microsoft SQL Server sources from one centralized user interface. The seamless integration of Multi-Host eliminates the need to create and maintain individual sources and thus reduces the time to create multiple sources. The SailPoint Multi-Host solution helps to optimize account and entitlement aggregation of multiple servers by creating pre-configured aggregation groups. This guide is designed to give specific information about the requirements and fields needed to successfully configure a Multi-Host solution with Microsoft SQL Server sources. > [!NOTE] > > To view the latest features, enhancements, and fixes for all SaaS connectors, refer to the [SaaS Release Notes]() page. ## Supported Features The SailPoint Multi-Host source for Microsoft SQL Server supports the following features: - Create Multi-Host groups for Microsoft SQL Server (The maximum limit of servers you can manage is 250.) - Bulk Test Connection for all Microsoft SQL Server sources - Edit each Microsoft SQL Server source - List all Microsoft SQL Server sources on a Single Page - Grouped Account Aggregation of Microsoft SQL Server sources (Scheduled and Manual) - Grouped Entitlement Aggregation of Microsoft SQL Server sources (Scheduled and Manual) - Supports Microsoft SQL Server Connector Capabilities. Refer to the list of [Supported Features]() in the SailPoint Microsoft SQL Server connector documentation. ## Prerequisites - Configure at least one virtual appliance cluster and successfully test the connection. For instructions, refer to the [Virtual Appliance Reference Guide](). > **Important** > > Once a Virtual Appliance Cluster is selected and saved, it cannot be updated later. - Refer to the [Prerequisites]() page in the SailPoint Microsoft SQL Server connector documentation to ensure the Microsoft SQL Server sources meet the requirements for sources in SailPoint. - In SailPoint, the Admin user level permissions are required to access the Multi-Host configuration. - Refer to [Administrator Permissions]() in the SailPoint Microsoft SQL Server connector documentation for minimum permissions required by an Admin to perform specific operations within SailPoint Microsoft SQL Server connector. ## Supported Managed Systems Refer to the [Supported Managed Systems]() page in the SailPoint Microsoft SQL Server connector documentation for the latest supported managed systems of Microsoft SQL Server. # Troubleshooting If you encounter any of the following issues or errors, SailPoint recommends that you follow the guidance provided below to resolve the error before contacting SailPoint Support. For issues or errors that are not addressed in this connector guide, refer to the following resources for troubleshooting information: - [SailPoint Identity Services Documentation]() - [SailPoint Support Knowledge Base]() - [SailPoint Developer Community]() ## A multi-host source deletion is stuck in progress **Resolution**: Run this command in Postman to reset the source, then try deleting the source again from the UI. ```text curl --location --request POST 'https://sealinkteam.api.cloud.sailpoint.com/beta/multihosts/3031e1b1b6ac477f99649f1c46dbbe87/updateMultiHostStatus?multihostStatus=READY' \ --header 'Authorization: Bearer eyJXXXXXXXXXXQ' ``` > [!NOTE] > > Update the SailPoint tenant name and Bearer token in the cURL request with your specific values.