[MSSQL]Question of the Day

Article View: cn.bbs.comp.database

Article #616

Back to cn.bbs.comp.database Previous Next

#616

From: Galaxy��VOLUNTEERS��Database
Date: Wed, 26 Nov 2008 01:16

27 lines
1653 bytes

Q:
On a computer running Windows Server 2003 or later hosting a SQL Server 
instance, which of the following password policies are checked for a SQL 
Server login when CHECK_POLICY is ON and CHECK_EXPIRATION is OFF?
By Diana Dee




Answer: 
Enforce password history
Minimum password age
Minimum password length
Password must meet complexity requirements
Explanation: There is nothing written specifically indicating which 
policies are checked by CHECK_POLICY. The answer was determined by 
experimentation (SQL Server 2005 SP2 on Vista). A SQL Server login was 
created, then a query window was opened with the connection made using that 
login. ALTER LOGIN WITH PASSWORD = '' OLD_PASSWORD = '' was run when 
various policies were applied. 
Password policy - http://msdn.microsoft.com/en-us/library/ms182717.aspx 
--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

[m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.28][m

Technical Details

Message-ID: <4dCdMe$ayb@bbs.sjtu.edu.cn>

Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,5d3ce33c2c6c6123
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: ENGLISH,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder.news-service.com!news.isoc.lu!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: [MSSQL]Question of the Day
Date: 26 Nov 2008 01:16:19 GMT
Organization: ��ˮ˼Դ
Message-ID: <4dCdMe$ayb@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1227662152.A