Username and Password requirements in SQL Server 2005

Username and Password requirements in SQL Server 2005

Post by UGV0ZX » Sat, 22 Apr 2006 07:31:02


Is the username and password requirements in SQL Server 2005 different from
SQL Server 2000 if SQL Server 2005 is installed with default settings? So
far, I know that if SQL Server 2005 is installed on Windows 2003, it will
enforce password complexity automatically.

Thanks.
 
 
 

Username and Password requirements in SQL Server 2005

Post by Michael Ho » Sat, 22 Apr 2006 12:32:32

Yes. SQL Server 2005 installed on Windows 2003 enforces the local password
policy for all SQL Server logins. SQL Server 2000 does not have this
capability, so they behave differently.

--
Mike
http://www.yqcomputer.com/
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

 
 
 

Username and Password requirements in SQL Server 2005

Post by Jens » Sun, 23 Apr 2006 20:41:31

But you can disable that on user / machine / domain level if you want
to (interesting if you have password brute force attacks for the sa
account, which will always force it to disable)

HTH, Jens Suessmeyer.

---
http://www.yqcomputer.com/
---