Solved

"Must Change" is turned on

Posted on 2014-03-25
2
524 Views
Last Modified: 2014-03-26
In SSMS 2008 I am trying to set my password so it doesn't force a password change. When I uncheck "Enforce Password Expiration" a popup errors:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON. (Microsoft SQL Server, Error: 15128)

How do I turn off "Must_Change"? thanks!

Their link to a help file is worthless:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=15128&LinkId=20476
0
Comment
Question by:Starr Duskk
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39953808
just make sure all three (below) are unchecked if you want you login password to never expire and not check any policy:

"Specify old password"
"Enforce password policy"
"Enforce password expiration"
0
 
LVL 2

Author Closing Comment

by:Starr Duskk
ID: 39957660
thanks! i'll give it a try!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Query with datetime 3 24
Help  needed 3 24
TSQL - How to declare table name 26 30
Better way to make a query with date filter. 5 27
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

778 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