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?

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