Microsoft SQL Server Connector

After you have set up a connection to a Microsoft Office 365 endpoint, you can use CA Identity Manager to do the following tasks:

Manage logins on MS SQL server platforms
Register endpoints, explore them for objects to manage, and correlate their logins with global users
Create and manage MS SQL server logins using MS SQL server‑specific account templates
Change login passwords and activations in one place
Synchronize users with their provisioning roles or synchronize users' logins with their account templates
Assign a MS SQL server account template to each of your MS SQL server endpoints
Use the SQL Default Policy to create logins with the minimum level of security needed to access an MS SQL server endpoint
Generate and print reports about MS SQL server logins and hosts

This connector supports IPv6, but not FIPS.

Note: Before you use the connector, you can set up Windows authentication. This is optional.