Saturday, June 24, 2006 1:40 PMHi, 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 5:14 PMModerator
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.
SQL Express team
Saturday, June 24, 2006 10:13 PMI 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, July 14, 2012 9:58 AM
Can we off the password policy so user does not need to give the strong password?