Home: The Essential FDO
Create a Username and Password for the ArcSDE Provider Connected to Oracle
![](../images/nav-prev-xp.gif)
Connection API
![](../images/nav-up-xp.gif)
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.
- On
the Windows Start menu, click Programs,
click Microsoft SQL Server, click Enterprise
Manager.
- 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.
- 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.
- Click
the tab labeled Server Roles, click the check-box
labeledDatabase Creators
- 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.
- Click OK.
The Confirm Password dialog box
is displayed.
- In
the Confirm Password dialog box, type password in
the text entry box labeled Password,
click OK.
- In
the SQL Server Login Properties - New Login dialog
box, click OK.