Home Forums SQL Server 2014 Administration - SQL Server 2014 What is the default sa password? RE: What is the default sa password?

  • January 13, 2014 at 5:02 pm

    #1679756

    keymoo (1/13/2014)

    If I install an instance with Windows Only authentication, and then change it to Mixed Mode, if I enable the sa login, the password has already been set. What is the default? If it's generated, how secure is it? Is the password generated? What algorithm is used for that?

    Unless someone changed it, the SA password is the one used when SQL Server was installed.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)