Provisioning
The Microsoft SQL Server connector supports provisioning, allowing you to create and manage accounts and entitlements in Microsoft SQL Server directly from SailPoint.
Prerequisite: Your system is configured for provisioning.
When SailPoint provisions new accounts to the source, it uses the attributes on the Create Account page as instructions or a template for what to include in the account. This page is also referred to as the provisioning policy.
When new access is granted on a source where a user does not already have an account, SailPoint automatically includes account creation in the provisioning. This applies whether provisioning is started from an access request or from an automated role or lifecycle state assignment.
For direct-connect sources, SailPoint automatically creates the account from this configuration. If the source is not configured as a direct-connect source, SailPoint creates and assigns a provisioning task to the source owner and includes the values for the source owner to use in manually creating the account.
Important
This section describes the default Create Account configuration. SailPoint recommends that you work with Services to define a provisioning configuration specific to your company's needs. Be sure to verify large changes to the provisioning policy before implementation. Failure to do so might cause provisioning to fail.
Default Create Account Attributes
The following generators create required information for a new Microsoft SQL Server account. You might need to edit the contents.
| Account Attribute | Generator | Description |
|---|---|---|
| *native_identity | Generator | Native identity represented by default as login Name |
| password | Generator | Account password for newly created server account |
| *type_desc | Static | Description type of the login |
Note
The Microsoft SQL Server source provisioning operation does not fail for the case-sensitive database.
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.