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?

10 of 36 people (28%) answered Yes
Recently 2 of 10 people (20%) answered Yes

Entry

Database: Microsoft: SQL server: User: Login: Change: How to change a login name? [security]

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


----------------------------------------------------------------------
--- Knud van Eeden --- 23 December 2003 - 00:37 am -------------------
Database: Microsoft: SQL server: User: Login: Change: How to change a 
login name? [security]
---
Steps: Overchange:
 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. -double click on 'Logins'
 8. -In the right pane you will then see a list
     of currently existing logins
 9. -Right click on the login name of your
     choice
     (e.g. 'sa')
10. -select from list 'Properties'
11. -Replace or fill in the password in the
     'Password' box
     1. Repeat this password
12. -Make sure you choose the correct database in
     the field 'Database'
13. -click button 'OK'
---
---
Internet: see also:
---
Computer: Database: Program: Microsoft: SQL server: User: Login: 
Create: How to add a new login name?
---
Computer: Database: Program: Microsoft: SQL server: User: Login: View: 
How to view all current login names?
----------------------------------------------------------------------