Microsoft SQL server settings

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

Steps to configure Microsoft SQL server

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 based on the database connection:
     • If you are connecting to the Microsoft SQL database, authenticate using any of the below methods,
       • SQL Authentication: Enter the Username and Password.
       • Windows Authentication: Enter the Domain Name, Username, and Password.
     • If you are connecting to the AWS SQL database, you can select SQL Authentication and enter the Username and Password.
     • If you are connecting to the Azure SQL database, you can select Azure Active Directory - Password and enter the Username and Password.
   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.

Steps to add a new attribute mapping 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.
   • Automation Category: Select the automation type from the drop-down menu.
4. Fetch the input for user creation from the table by mapping the DB Column Name with the corresponding LDAP Attribute Name.
5. Click Save to save the new configuration.

Steps to automate user creation

1. Click the Automation tab.
2. Select Automation from the left pane.
3. Click 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 or 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 More Options and 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 Microsoft SQL table for user creation.
   • Select Config: Select an attribute mapping configuration from the menu or click Add New Configuration, which will redirect you to the Application Integration Settings page. You can map the required database attributes with corresponding LDAP attributes and save them as a configuration.
   • Implement Business Workflow: Select this option if the automation has to be executed through a workflow.
   • Execution Time: Configure the time and frequency at which the automation should be executed.
4. Click Save to save the settings, or click Save & Run to save the settings and run the automation instantly.

Actions supported

• Duplication check using templates
  • User creation
  • User modification
• 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