Creating server logins for users and groups (Model Explorer)
You can create a Server login for an Active Directory user or group. Logins are used for SQL Server authentication. To allow users or groups to connect to the SQL Server instance, you must create a server login for each user and group that you want to give database access to.
 |
Consider the following points before you create logins for users and groups:
1. Only Modeler System Administrators and SQL Server Administrators can create server logins.
2. PTC Modeler supports Forest users and groups of two-way trusted domains.
3. PTC Modeler supports Forest users of one-way trusted domains.
|
Creating a server login
To create a server login:
1. Start Model Explorer. For more information, refer to Starting Model Explorer.
2. In the left navigation pane, expand the SQL icon.
3. Right-click on the server to which you want to add a server login and select > . The Create Login dialog box appears.
4. In the Enter User or Group Name text box, enter the users and groups for which you want to create logins. Multiple entries must be separated by a semicolon (;). The users and groups should be in the format:
◦ <domain\username>—to create a user login.
◦ <domain\groupname>—to create a group login.
5. Click Verify to verify the groups and usernames that you have entered. Correct the errors if there are any.
6. Select the Modeler System Database Administrator check box to provide system administrator privileges to the groups and users. Modeler System Database administrators have rights to create, modify and delete users from the Modeler database, but do not have access rights to create, modify or delete models or work with Modeler. To provide access to databases, you must also select the Database Specific Roles.
7. Select the Database Specific Roles check box to provide database administrator privileges to the groups and users. After you select this check box, a list of all databases is populated. Select the database for which you want the users to have appropriate access rights.
8. Click Create to create the server logins.
|
|
1. User name or Group name is verified against SaMAccountName in Active Directory.
2. Modeler Application Users will be given write access. User permissions can be changed to Read Access using Change Principal Role menu action on respective databases.
|