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> ?????

Answer 1

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

Answer 2

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.

Answer 3

Hi,

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