The following features are supported in the MS SQL templates.
Read all login accounts and their attributes.
Read all server roles.
Read all login role membership.
Read all role membership.
Change password for logins.
Lock or unlock logins.
Read all database roles or application roles.
Read all user role membership.
Read all role membership.
Change password for users.
Lock or unlock users.
Ensure that the following prerequisites are met before configuring the MS SQL database:
Before creating a synchronization project with the native database connector, ensure that the information about the following attributes is available:
MS SQL Server Name
Database that is to be connected
For more information on assigning server function, refer to the One Identity Manager Configuration Guide.
The synchronization project for MS SQL is classified into server level and database level.
The following procedure describes how you create and configure synchronization projects for server-level projects in Microsoft SQL.
Open the Synchronization Editor.
The schema loading window is displayed.
Follow on-screen instructions until the Provisioning Capability window is displayed.
The synchronization project is created successfully.
After the creation of the synchronization project, set the variables value in the DefaultUserPassword field.
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center