locked
Policy for password for sql Login RRS feed

  • Question

  • I created a sql login with name student and password 1

    it was created and when i tried login in it shows error "Login Failed";

    when i changed pasword from 1 to a, It worked,

    I want to know what are the password policy in creating logins.


    Regards Kumar Gaurav.

    Monday, February 13, 2012 2:09 PM

Answers

  • Gaurav,

     Its because the password is very simple and weak, but still you want the same password then you can do by CHECK_POLICY = OFF as follows

       
    create login a with password = 'b', CHECK_POLICY = OFF
     However if you are interested to know more about the password policy then visit http://msdn.microsoft.com/en-us/library/ms161959.aspx


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


    Tuesday, February 14, 2012 6:48 AM

All replies

  • password 1 and 'a' are too weak ...... Do you create a login via SSMS?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Monday, February 13, 2012 2:13 PM
    Answerer
  • Hi

    When you create the user initially the option "user must change password at next login" is enabled by default and this is why you couldn't login first time and the when you changed the password you actually satisfied the must change password policy hence sql permitted you in

     

    VT


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker


    • Proposed as answer by Naomi N Monday, February 13, 2012 2:28 PM
    • Edited by SimpleSQL Monday, February 13, 2012 2:29 PM
    Monday, February 13, 2012 2:14 PM
  • i had changed the password from login account only without loging in with account named student

    Regards Kumar Gaurav.

    Tuesday, February 14, 2012 6:37 AM
  • password 1 and 'a' are too weak ...... Do you create a login via SSMS?

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/


    yes i used SMSS

    Regards Kumar Gaurav.

    Tuesday, February 14, 2012 6:37 AM
  • Gaurav,

     Its because the password is very simple and weak, but still you want the same password then you can do by CHECK_POLICY = OFF as follows

       
    create login a with password = 'b', CHECK_POLICY = OFF
     However if you are interested to know more about the password policy then visit http://msdn.microsoft.com/en-us/library/ms161959.aspx


    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


    Tuesday, February 14, 2012 6:48 AM