faqts : 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?

12 of 14 people (86%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

Database: Microsoft: SQL server: User: Login: Create: How to add a new login name? [security]

Dec 22nd, 2003 15:36
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 23 December 2003 - 00:35 am -------------------
Database: Microsoft: SQL server: User: Login: Create: How to add a new 
login name? [security]
---
Steps: Overview:
 1. -Start Microsoft SQL server 'Enterprise manager'
 2. -Select your database
 3. -In the left pane click '+'
     of 'Microsoft SQL Servers'
 4. -click '+' of 'SQL Server Group'
 5. -click '+' of your server
      (e.g. (local) (Windows NT))
 6. -click '+' of 'Security'
 7. -right click
 8. -select from list 'New login...'
 9. -select tab 'General'
10. -First select the domain
      e.g. DELLI8500
11. -Supply a login name in 'Name:'
     e.g.
      test
     1. If you chose
        'o Windows authentication'
        it must be an already existing
        Microsoft Windows login name
        (e.g. 'administrator')
     2. Otherwise choose
        'o SQL Server Authentication'
        supply your password
12. -Important: you also have to indicate
     which database is involved in the
     'Database:' field.
13. -When all the necessary fields have
     been filled in, press the button 'OK'.
---
---
Internet: see also:
---
Computer: Database: Program: Microsoft: SQL server: User: Login: View: 
How to view all current login names?
---
Computer: Database: Program: Microsoft: SQL server: User: Login: 
Change: How to change a login names?
----------------------------------------------------------------------