Entry

Database: Microsoft: SQL server: User: Add: How to add a user to a database? [Northwind]

Dec 12th, 2003 14:38
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 12 December 2003 - 23:38 pm -------------------

Database: Microsoft: SQL server: User: Add: How to add a user to a 
database? [Northwind]

---

Steps: Overview:

 1. -Start Microsoft SQL server 'Enterprise manager'

 2. -Select your database

     1. -In the left pane click '+'
        of 'Microsoft SQL Servers'

     2. -click '+' of 'SQL Server Group'

     3. -click '+' of (local) (Windows NT)

     4. -click '+' of 'Databases'

     5. -click '+' of your database

          e.g. select the 'Northwind database'
               on my computer here

     6. -select from list 'Users'

     7. -right click

     8. -select from list 'New database user...'

     9. -select tab 'General'

    10. -select '<new>' from 'Login name' list

    11. -this will open a dialog box
         'SQL Server Login Properties - New login'

         1. -Fill in e.g.

              Name = <your new login name>

                     e.g. ASP.NET

              Domain = <your computer name>

                       e.g. DELLI8500


         2. -click button 'OK'

 3. -This will create the username <your computer name>\<your user 
name>

----------------------------------------------------------------------