?
Solved

user must change password at next login is greyed out

Posted on 2009-12-17
9
Medium Priority
?
1,867 Views
Last Modified: 2013-12-11
I'm trying to implement a password expiration policy with SQL 2005, however the checkbox on user security "User must change password at next login" is greyed out.

How  do I correct this?

Thanks
0
Comment
Question by:jdr0606
  • 5
  • 4
9 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26077559
It would by default be greyed out..
And would work when you check Enforce Password Policy..
User must Change Password at next login is a policy inherited from Windows Group policies and hence this way..

Workaround:

You can use it out from TSQL Statements like:

CREATE LOGIN test_login WITH PASSWORD = 'ur_password' MUST_CHANGE;
GO

Note: MUST_CHANGE is applicable to SQL Server logins and for Windows Logins it needs to be set in Group Policies as mentioned earlier..
0
 

Author Comment

by:jdr0606
ID: 26077578
I have 200+ user logins that even if I check enforce password policy, enforce expiration is selectable but user must change password stays greyed out on any user.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26077597
Yes.. That is what I meant and "User must Change Password at next login" would be greyed by default.
And it would work only based on your Windows Group Policy settings..
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:jdr0606
ID: 26077630
Call me stupid, but I assume you are telling me that Windows Group Policy is set to not allow "User change password at next login"?
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 26077639
Ok... Let me try to represent it in other words..

Windows Group Policies controls that option and hence it is greyed out..
But we can Control it using MUST_CHANGE option either in CREATE LOGIN or ALTER LOGIN statements..

Hope this clarifies.
0
 

Author Closing Comment

by:jdr0606
ID: 31667639
Thanks!
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26077658
Welcome..
0
 

Author Comment

by:jdr0606
ID: 26084429
BTW do you know specifically which Windows Group Policy controls this?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26096690
This policy would be set by Windows Domain Controller ( your Domain server) and published / enforced in all your local servers/ clients using Group policy updates..

Script to do that option is given below and this does the request in your LDAP server..

http://gallery.technet.microsoft.com/ScriptCenter/en-us/7e44bd45-f49f-4e47-ae00-b18f544e478f
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question