Configuring provisioning for Microsoft SQL

This configuration provisioning guide provides the basic information that is needed to install and configure the Microsoft SQL adapter. The adapter enables connectivity between the IBM® Security Verify server and a system that runs the Microsoft SQL server.

Before you begin

Table 1. Prerequisites
Prerequisite	Description
Operating system	Microsoft Windows 10 Microsoft Windows 2016 Microsoft Windows 2019
Microsoft SQL Server	Microsoft SQL Server 2016 Microsoft SQL Server 2019 The system where the adapter is installed must have SQL connectivity to the system where the SQL Server is installed.
Multiple Sites and Servers	A single SQL Server Adapter installation can be used by an organization with multiple MSSQL sites or multiple servers at an SQL site.
Network Connectivity	TCP/IP network
System Administrator authority	To complete the adapter installation procedure, you must have system administrator authority.
Identity server	The following servers are supported: IBM Security Verify Governance Identity Manager v10.0 IBM Security Verify Governance v10.0 IBM Security Identity Manager v7.0.x IBM Security Identity Manager v6.0.x IBM Security Privileged Identity Manager v2.x BM Security Identity Governance and Intelligence v5.2.x

For installation information, refer to the following link for the installation process:https://www.ibm.com/support/pages/system/files/inline-files/$FILE/sql_60_book.pdf

About this task

Provisioning provides the following features.

Create new users: New users that are created through Verify are also created in the Microsoft SQL application.

Delete users: Deactivating the user or disabling the user's access to the application through Verify deletes the user in the Microsoft SQL application.

Modify user profile: Updates made to the user's profile through Verify are pushed to the Microsoft SQL application.

User suspends and restore: Suspending a user through Verify deactivates the user and restoring the user through Verify activates the user in the Microsoft SQL application.

User synchronization and remediation: Synchronization fetches all the Microsoft SQL application users, creates the users on Verify, and according to the remediation policy, modifies the attributes. Group synchronization fetches all the target application groups in Verify.

Fine grained entitlement: Fine grained entitlement is supported for the Microsoft SQL application. Synchronization fetches all Microsoft SQL application groups. Users can be added to or removed from groups.