Set up a user account on a SQL server

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

To set up a user account on a SQL server

Open Enterprise Manager.
In the console tree, double-click Microsoft SQL Servers, click SQL Server Group, and then SQLComputerName (Windows NT).
Double-click Databases, and then double-click your database of choice.
Right-click Users, and then click the New Database User menu.
Next to Login name, type:

domain**\**username
Next to User name, type your user name.
Select the Public check box, and then select all of the following objects:
- db_owner
- db_accessadmin
- db_securityadmin
- db_ddladmin
- db_datareader
- db_datawriter
- db_backupoperator
Important
- Do not select db_denydatareader or db_denydatawriter. These objects allow members to deny Read or Write permissions to data in the database.

Notes

To open Enterprise Manager, click Start, point to Programs, click Microsoft SQL Server, and then click Enterprise Manager.
Before you begin, confirm that a domain and your administrative credentials are set up:
- You have permissions to read from and write to the SQL Server database.
- Your user name has administrative credentials on each of the above computers; you will use it to log on at all times.
- This is a quick start procedure only. Consult your Microsoft SQL Server documentation for detailed instructions on setting up and configuring a SQL database.
- Windows Server 2003 family, not Microsoft SQL Server, authentication is used when you connect to a SQL server for performance monitoring purposes.

Your server might function differently based on the version and edition of the operating system that is installed, your account permissions, and your menu settings. For more information, see Viewing Help on the Web.