Create a Username and Password for the ArcSDE Provider Connected to SQL Server

Create a Username and Password for the ArcSDE Provider Connected to Oracle

Connection API

Connecting to the ODBC Provider

 

Create a Username and Password for the ArcSDE Provider Connected to SQL Server

The following procedure adds a new login user named name with password password who must login to the SQL Server using SQL Server authentication. The user named name is given the global privilege, Database Creators, and is added to a database with privileges, db_ddladmin, db_datareader, and db_datawriter.

1. On the Windows Start menu, click Programs, click Microsoft SQL Server, click Enterprise Manager.
2. In the Enterprise Manager application window, click Console Root, click Microsoft SQL Servers, click SQL Server Group, click GroupName, click Security, click Logins, click New Login. The SQL Server Login Properties - New Login dialog box is displayed.
3. In the SQL Server Login Properties - New Login dialog box, click the tab labeled General, type name in the text entry box labeled Name, click the radio button labeled SQL Server Authentication, type a password in the text entry box labeled Password.
4. Click the tab labeled Server Roles, click the check-box labeledDatabase Creators
5. Click the tab labeled Database Access, click the check-box in the column labeled Permit next to the name of the database to which you are adding this user, click the check-boxes in the column labeled Permit in Database Role next to the labels db_ddl_admin, db_datareader, and db_datawriter.
6. Click OK. The Confirm Password dialog box is displayed.
7. In the Confirm Password dialog box, type password in the text entry box labeled Password, click OK.
8. In the SQL Server Login Properties - New Login dialog box, click OK.