Online Shopping : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

15 of 27 people (56%) answered Yes
Recently 5 of 10 people (50%) answered Yes

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>
----------------------------------------------------------------------