Question of the Day

Re: QOD 2006-10-09

xmldeveloper — Tue, 10 Oct 2006 11:52:30 GMT

On Windows 2000 and Windows XP you cannot use the MUST_CHANGE option.

The password complexity checking for Windows 2000 is very simple, you are not allowed to use the following password: null or empty, the computer name, the login name, 'password', 'admin', 'administrator', 'sa', or 'sysadmin'.

Re: QOD 2006-10-09

ggciubuc — Tue, 10 Oct 2006 11:41:21 GMT

The answer is:

"SQL Server 2005 can use Windows password policy mechanisms only on Windows Server 2003 and above(look for must_change option in Books Online)"

Re: QOD 2006-10-09

xmldeveloper — Mon, 09 Oct 2006 12:15:35 GMT

Hints:

One of the selected options cannot be used with Windows 2000 and Windows XP operating systems.
Another of the remaining two options will generate an error on Windows 2003 and above as well as on Windows 2000 and Windows XP due to the arguments supplied.

QOD 2006-10-09

ggciubuc — Mon, 09 Oct 2006 11:38:22 GMT

Click on OK button and you will have an error. Why?
(At this kind of question in a day I answer in other day you answer, today is a day when you'll answer)