locked
SQL LOGIN with weak password RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I need to create a SQL LOGIN with weak password.

    Is there a way to change the password policy or bypass for a specific LOGIN ?

    I've tried this:


    Saturday, January 31, 2015 9:57 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes it is possible, please try something similar to the below script:-

    USE [master]
    GO
    CREATE LOGIN [test] WITH PASSWORD=N'test', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
    GO

    Please mark the answer as helpful if i have answered your query. Thanks and Regards, Kartar Rana

    Saturday, January 31, 2015 2:55 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Is there a way to change the password policy or bypass for a specific LOGIN ?

    SQL Azure doesn't allow the CHECK_POLCY clause.  See https://msdn.microsoft.com/en-us/library/ms189751.aspx

    Why would you want to create a weak password?  I think the CHECK_POLICY option is intended only for legacy applications.

     

    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Saturday, January 31, 2015 4:47 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    That works, but not in azure database (sql as a service).

    Thanks.

    Tuesday, February 3, 2015 10:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    Yes, that's true, I've received confirmation from MS support.

    That's unfortunate, because this way I can't migrate a SQL DB that is currently used by more than 1500 clients (POS with hardcoded SQL server user and password)

    Tuesday, February 3, 2015 10:58 PM