Wednesday, March 7, 2012

Local Security Settings - maximum password age

We would like to use the SQL Server 2005 Express at our customers.

But now we have to meet the local security settings of the PC.

What is happening with the database users password (e.g. sa) when the "Maximum password age" in the "local security settings" for the password policy is to >0 (e.g. 30 days)?

Because this cause a frequently change of the passwords at the customers!!!!!!

Password policy are only applied to SQL Server 2005 which are installed in Windows 2003 Servers. The local settings on the WIndows machine wont effect the accounts at all.

Jens K. Suessmeyer

http://www.sqlserver2005.de

No comments:

Post a Comment