Adding database-authenticated logins to a SQL Server database

Logins created directly in the Microsoft SQL Server instance are database-authenticated logins. When you connect to the geodatabase with a database-authenticated login, you must provide the SQL Server managed login name and password. After the login is created, create a user in each database the login needs to access and map the login to it.

Steps:

1. Connect to your SQL Server Instance.
2. Navigate to the Security folder, right-click Logins, and choose New Login.
3. On the General page, type a user name in the Login name field.
4. Choose the SQL Server authentication option.
5. Type a password for the login in the Password field.
6. Type the same password in the Confirm password field.
7. You can alter other configurations on the General page or accept the defaults. See the SQL Server Books Online for instructions if you want to alter these configurations.
8. Click OK to close the Login – New dialog box.
9. In the Object Explorer, expand the database the user needs to access.
10. Expand the Security folder under the database.
11. Right-click the Users folder and click New User.
12. Type the user name in the User name field.
13. Click the ellipse button next to the Login name field to browse for the login you added to the SQL Server instance in the first 6 steps.
14. If the user requires a matching schema (for example, the user will own data in the geodatabase), type the schema name in the Default schema field. Remember, the user name and schema name must be the same if this user is going to own data.
15. You can place the user in a role by checking one of the roles in the Role Members list.
16. Click OK to close the Database User – New dialog box.
17. If the user will own data in the geodatabase, right-click the Schemas folder in the Object Explorer and click New Schema.
18. Type the same schema name you typed in the Default schema field for the user.
19. Click Search to choose the schema owner.
20. Type the user name and click Check Names.
21. Click OK to close the search dialog box.
22. Click OK to close the Schema – New dialog box.