Re: SQL2000
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/27/03
- Next message: Mal Ball: "SQL Security & Windows XP"
- Previous message: Narayana Vyas Kondreddi: "Re: Lock of Object if i create users with a script file"
- In reply to: lwmccksg: "SQL2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 27 Jul 2003 12:19:20 +0100
You need to set passwords manually for all logins. Or write a stored
procedure or DMO application that loops through the logins collection and
changes the passwords.
If you need some help generating complex passwords, try this:
http://vyaskn.tripod.com/code.htm#randp
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ What hardware is your SQL Server running on? http://vyaskn.tripod.com/poll.htm "lwmccksg" <lwm_cck@yahoo.com> wrote in message news:3f232ebc$1@news.starhub.net.sg... Currently our SQL 2000 was configured in mixed mode authentication. How am I able to set it to have complexity password in SQL 2000, for all users including sa account? This is to discourage easy guessable and numeric password. Thanks in advance Lawrence Lau
- Next message: Mal Ball: "SQL Security & Windows XP"
- Previous message: Narayana Vyas Kondreddi: "Re: Lock of Object if i create users with a script file"
- In reply to: lwmccksg: "SQL2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
