HOW TO
Instructions provided describe how to create a new SQL Server Authenticated user within Microsoft SQL Server Management Studio to be used with an Enterprise Geodatabase.
The instructions below are specific for creating users for use in conjunction with an Enterprise Geodatabase. Please consult the database administrator to perform such operations.
Further information can be found in the ArcGIS Desktop Help. Please refer to the Related Information section below.
Note: If it is necessary to create users manually instead of using the Create Database User tool, please see Create Database User (Data Management).
Note: To use SQL Server Authentication, the SQL Server Database Engine must use mixed mode authentication. For more information see the Microsoft SQL Server Choose an Authentication Mode documentation.
Note: This folder is found after expanding the SQL Server instance in the Object Explorer.
Note: If 'Enforce password policy' is checked, the password must conform to your organization's password policy. See the Microsoft SQL Server Password Policy documentation for more information.
Note: For users that create tables, feature classes or views, the User and Default Schema must be the same.
Get help from ArcGIS experts
Download the Esri Support App