Skip to content

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.

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.