Active Directory user accounts are used to connect to the SQL Server instance and set database access permissions. You can use Active Directory Domain Services to create an AD user account on a domain controller machine.
To create a user account, do the following:
1. On the domain controller machine, start Active Directory Users and Computers.
2. In the left navigation pane, expand the domain, then click on Users. The list of current users and groups appears.
3. Right-click on Users, point to New, and then click User. The New Object wizard appears.
4. Enter the user’s logon information:
◦ First name — Specifies the user’s first name.
◦ Last name — Specifies the user’s last name.
◦ User logon name — Specifies the Active Directory logon that is used by Integrity Modeler.
The drop-down list specifies a domain on which the user will be created.
5. Click Next.
6. Set a password for the user.
We recommend selecting the check box next to Users must change password at next login.
7. Click Next to continue.
8. Review the information for the new user, and then click Finish to create the user.
9. Confirm that the user appears in the User
10. Grant the user login permissions to the Integrity Modeler SQL Server instance. For more information, see
After creating an active directory user, you should grant the user the following permissions in SQL Server: