Identity Manager 8.1 - Administration Guide for Connecting to Native Databases through Database Systems Integration Module

Database Systems Integration Module Installing DSI Working with Oracle Database Working with MSSQL Working with SAP HANA Troubleshooting

Features supported

Features supported

The following features are supported in the MS SQL templates.

Features supported for MS SQL Server-level template
  • Read all login accounts and their attributes.

  • Read all server roles.

  • Read all login role membership.

  • Read all role membership.

  • Create and delete operations for login.
  • Change password for logins.

  • Lock or unlock logins.

  • Change role membership.
  • Change login role membership.
Features supported for MS SQL Database-level template
  • Read all user accounts and their attributes.
  • Read all database roles or application roles.

  • Read all user role membership.

  • Read all role membership.

  • Create and delete operations for users.
  • Change password for users.

  • Lock or unlock users.

  • Change role membership.
  • Change user role membership.

Prerequisites to configure the MS SQL database

Prerequisites to configure the MS SQL database

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

      • Username
      • Password
      • Database that is to be connected

    • The native database configuration server function must be enabled on the Designer for the Job server.

    For more information on assigning server function, refer to the One Identity Manager Configuration Guide.

  • Creating a synchronization project

    Creating a synchronization project

    The synchronization project for MS SQL is classified into server level and database level.

    Synchronization project for server level

    Synchronization project for server level

    The following procedure describes how you create and configure synchronization projects for server-level projects in Microsoft SQL.

    To create synchronization project
    1. Open the Synchronization Editor.

    2. On the Start page, select Start a new Synchronization Project.
    3. On the Choose target system page, select the Native Database Connector check box and click Next.
    4. Select Create New System Connection.
    5. Select SQL Server.
    6. Provide the name of the SQL server required to establish a connection in the SQL Server Name field.
    7. Provide the Username and Password for the privileged service account or an account that has the sysadmin server role.
    8. Select master database to create the project for managing server-level objects.
    9. Provide the display name and the identifier.
    10. Select the DSI_MSSQL_ServerLevel_Configuration.xml configuration file available at DSI/ConfigFiles in the DSI installation folder and click Next.
    11. Review the preferences and click Next until the Save Configuration window is displayed. Ensure that the configuration field is empty.
    12. Click Next.
    13. Review the preferences and click Finish.

      The schema loading window is displayed.

    14. After the schema is loaded, the Template Selection page is displayed.
    15. Select MSSql Server Level Template and click Next.

      Follow on-screen instructions until the Provisioning Capability window is displayed.

    16. Select the synchronization server and click Finish.

      The synchronization project is created successfully.

    After the creation of the synchronization project, set the variables value in the DefaultUserPassword field.

    Related Documents