MS SQL server settings

    MS SQL is a database system which stores and manages information. By integrating ADManager Plus and MS SQL server, users can be automatically created in Active Directory based on the new user data entered in the MS SQL database.

    Steps to configure 'MS SQL server' settings

    1. Click the Automation tab.
    2. In the left pane, under Configuration select Application Integrations.
    3. Under Database, click Microsoft SQL Server and select Click to Configure.
    4. In the Microsoft SQL Server Details section, configure the following:
      • Server Name: Enter the server name.
      • Instance Name: Enter the instance name and port number.
      • Authentication: Select any of the following authentication types:
        • SQL Authentication: Enter the Username and Password.
        • Windows Authentication: Enter the Domain Name, Username and Password.
        • Azure Active Directory - Password: Enter the Username and Password of the Azure AD user account.
      • Note: The user account credentials used for authentication should at least have the db_datareader role in SQL Server.

    5. Click Test Connection and Save to establish the connection and save the settings.
    Note:
    • Click the Add Server option to configure multiple MS SQL servers.
    • The Enable Integration button is turned on by default. Toggle it off to disable MS SQL integration.

    Steps to add a new configuration

    1. Click Add New configuration and enter a suitable name.
    2. In the Description field enter the details about the new configuration.
    3. Configure the following details:
      • Select Server: Select the server name from the drop down menu.
      • Select Database: Enter the database name.
      • Table Name: Enter the name of the table in MS SQL database.
      • Automation Category: Select the automation type from the drop down menu.
    4. Fetch the input for user creation from the MS SQL table by mapping DB Column Name to the LDAP Attribute Name.
    5. Click Save to save the new configuration.

    Steps to automate user creation

    1. Click on 'Automation' tab.
    2. Select 'Automation' from the left pane.
    3. Click on 'Create New Automation' and configure the following:
      • Automation Name: Enter a name for the automation.
      • Description: Add a brief note about the automation.
      • Automation Category: Choose 'User Automation' from the menu.
      • Select Domain: Select the domain/OUs where the automation should run. Child OUs can be eliminated by selecting 'Exclude Child OU(s)' option.
      • Automation Task/Policy: Select 'Create Users' from the menu.
      • Template to be applied: Select the template to be applied for user creation.
      • Select Data Source: Click on 'More Options' beside the 'Location of CSV' option. Select 'MS SQL Server' from the menu. Enable 'Ignore current records in DB' to ignore the already processed records and consider only the unprocessed records in the MS SQL table for user creation.
      • Select Config: Select a configuration from the menu. Or click on Add New Configuration to add new configuration settings.
      • Implement Business Workflow: Select this option if the automation has to be executed through a workflow.
      • Execution Time: Configure the automation execution time and repeat the execution using 'hourly', 'daily','weekly','monthly', or 'more' options.
    4. Click 'Save' to save the settings or 'Save & Run' to save the settings and run the automation instantly.

    Actions supported

    • Duplication check using templates
    • Management actions using automation

      The following AD actions can be performed in ADManager with the Automation feature.

      • Create user accounts
      • Modify user attributes
      • Modify user accounts by template
      • Reset password
      • Unlock users
      • Disable users
      • Enable users
      • Delete users
      • Run custom scripts
      • Move users to a different container
      • Add users to groups
      • Remove users from groups
      • Create mailbox
      • Disable or delete mailbox
      • Move home folder
      • Delete home folder
      • Revoke Microsoft 365 licenses
      • Manage user photos
      • Disable Skype for Business accounts
      • Auto reply

    Don't see what you're looking for?

    •  

      Visit our community

      Post your questions in the forum.

       
    •  

      Request additional resources

      Send us your requirements.

       
    •  

      Need implementation assistance?

      Try onboarding