SQLServer Database Configuration

Step 1 Step 2 Step 3 Step 4 Step 5


Step 3: Create a SQLServer User for the SAMPLE database

  • Create a SQLServer user named WSDEMO with a password of wsdemo1, for the SAMPLE database.

    Use SQLServer's Enterprise Manager GUI, or type this command into SQLServer's Query Analyzer:

    1. sp_addlogin WSDEMO, wsdemo1, SAMPLE

    Next, add the user to the database and grant user permissions. Use SQLServer's Enterprise Manager GUI or execute each of these commands, separately, in SQLServer's Query Analyzer:

    1. use SAMPLE
    2. sp_grantdbaccess WSDEMO
    3. grant all to WSDEMO
Please see SQLServer documentation for more information on SQLServer's Enterprise Manager and Query Analyzer tools.

Take Note!
  • Be sure you use all lower case letters when creating the wsdemo1 password.
  • The WSDEMO username is shown in all uppercase, but can be entered in either upper or lower case.