Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WindChaser
Posting Yak Master
225 Posts |
 Posted - 2008-06-03 : 15:24:30
|
| Hi folks.I just tried to perform the install of SQLServer 2005 Express on a Win 2003 SP2 machine and the install failed with the rejection of the SA password. Currently, our pwd is 1 uppercase letter, 4 lowercase letters and 1 number for a total of 6 characters. Other installations on Win 2003 SP1 have worked fine in the past. I read in a recent version of Books Online that the SA pwd guidelines might have recently changed and that 8 characters might now be required. My question is: do these new 8 character guidelines apply only to the sa pwd or to all logins? Thanks!Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-03 : 15:25:58
|
| When you create logins, you can specify whether or not to enforce the password policy.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2008-06-03 : 15:51:32
|
| Thanks Tara!We've never specified. Is the default to enforce or not to enforce? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-03 : 15:54:09
|
| In Management Studio, when using the GUI to create logins, the option is checked by default. I'm not familiar with SQL Express though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2008-06-03 : 15:58:06
|
| Interesting. Do you know if there is any way on the installation command line to specify if the option can be disabled? This is catching us by surprise and I'd like to avoid the issue for the time being if at all possible. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 16:44:30
|
| The option is per logon create. |
|
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2008-06-03 : 17:26:03
|
| I checked out the commandline options and it can't be done otherwise. But I figure that I can set a temporary SA pwd at the commandline for the installation, then immediately run an ALTER LOGIN to change the SA pwd to my standard pwd and remove the policy enforcement. Thanks everyone! |
|
|
|
|
|
|
Urgent: Strong SAPWD required on Win2003