Creating a user
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.
 |
While creating users, ensure that you do not use spaces or other special characters. For more information, refer the following link. https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver15.
|
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, and select > . 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 PTC 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 PTC 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:
1. Access to the server. See Creating server logins for users and groups (Model Explorer)
2. Access to a database. See Adding principals to a database (Model Explorer)
For more information about Active Directory, refer to the Microsoft help:
Active Directory Domain Services