none
Blank password from command line installation

    Question

  • Hi, I need blank password for user "sa" when I instaling SQL 2005 Express from command line. SAPWD=<strong password> --> SAPWD=<blank password> ?????
    Saturday, June 24, 2006 1:40 PM

Answers

  • If you install SQL Express to use Windows Authentication (the deafult) you don't need to supply an SAPWD. (In fact the SA account is disabled in this case for SQL Express.) If you are installing using SQL Authentication you need to supply a strong password, I don't know of a way around this.

    I can't think of any reason that I would ever let the SA user have a blank password. You might as well just send hackers a key to you house, the dates of your next vacation and a note telling them to have a good time while you're away. Security is provided for very good reasons, you should not try to defeat it in this way.

    Regards,

    Mike Wachal
    SQL Express team

    Saturday, June 24, 2006 5:14 PM
    Moderator
  • I agree you should never use a blank password, from memory you needed to supply a password for the sa account from sql 2000 sp3 onwards.
    Saturday, June 24, 2006 10:13 PM

All replies

  • If you install SQL Express to use Windows Authentication (the deafult) you don't need to supply an SAPWD. (In fact the SA account is disabled in this case for SQL Express.) If you are installing using SQL Authentication you need to supply a strong password, I don't know of a way around this.

    I can't think of any reason that I would ever let the SA user have a blank password. You might as well just send hackers a key to you house, the dates of your next vacation and a note telling them to have a good time while you're away. Security is provided for very good reasons, you should not try to defeat it in this way.

    Regards,

    Mike Wachal
    SQL Express team

    Saturday, June 24, 2006 5:14 PM
    Moderator
  • I agree you should never use a blank password, from memory you needed to supply a password for the sa account from sql 2000 sp3 onwards.
    Saturday, June 24, 2006 10:13 PM
  • Hi,

    Can we off the password policy so user does not need to give the strong password?

    Saturday, July 14, 2012 9:58 AM