Welcome
Login  |  Register
Tuesday, January 06, 2009
  Search
You are here:Knowledge Base
 
More Information
More Information
More Information
More Information
 
 

 Please Register or login to view our private forums, it is free!!
Forums > Knowledge Base Systems > MSSQL
Subject: sql login expired
Prev Next
You are not authorized to post a reply.

Author Messages
cbingram@casit.netUser is Online
Posts:356
04/05/2007 5:46 PM  
  • symptom;
    • SQL login expired because the option was enabled;
    • Research; sql server help;  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/scsql9/html/c0040c0a-a18f-45b9-9c40-0625685649b1.htm
    • msft describes the sql auth policies  embedded in sql2005 and Win2k3
  • solution;
    • In most case, you will have to change the password, disable the MUST_CHANGE option, then change the password back to the orginal value.
    • also;
    • alter login
      with
      check_policy=off, check_expiration=off
You are not authorized to post a reply.
Forums > Knowledge Base Systems > MSSQL > sql login expired


ActiveForums 3.7
Privacy Statement  |  Terms Of Use  
Copyright 2006-7 Vigilant Support