Creating a SQL Server Database Login Account

The system administrator ("sa") account in SQL Server allows access to all the databases and settings in SQL Server.  Since Blackthorne users only need access to the Blackthorne database, you should create a login account that only has access to what is absolutely necessary.  Then, when users switch to the database from other computers, they will use this new account.

To create a new login account:

1. From the Start menu in Windows select Start|All Programs|Microsoft SQL Server 2005|SQL Server Management Studio Express.
2. In the sidebar on the left, expand the database, then the Security folder, then click Logins.

3. From the Logins window, right click the Logins box and select New Login...

4. On the Login window, enter a Login name.  Then select SQL Server authentication and enter a Password and Confirm password.  This is the password that will keep bad guys out of your data so make sure you use a strong password that won't be easily guessed, and make sure you remember it.  It is also the password that you will use when switching databases within eB.

5. In the Default database box, select your Blackthorne database.  Click OK to return to the Logins window.  

6. You now have a new SQL Server Login account.  Next, you will create a database user and link it to this account.

To create a database user:

1. In the sidebar in the SQL Server Configuration Manager, expand Databases.

2. Find the name of your Blackthorne database under Databases and expand it.

3. Expand Security and then select Users.
4. In the Users window, right click and select New User... in the context menu.
5. In the User name, enter a database user name.  This should be the same name as the SQL Login you just created.

6. In the Login name, enter the same name you used in User name.  This is associating the Login account you created with the database user that you are now creating.
7. In the Role Members list, check db_datareader, db_datawriter, and db_ddladmin to set the permissions that the new database user will have.
8. Click OK to exit, and then File|Exit to leave the SQL Server Management Studio.