Prev: SQL 2005 Mirroring Databases
Next: Unmanaged code from SQLServer 2005 CLR
From: Igor Solodovnikov on 25 Jan 2006 07:30
Do you run SQL Server installer from command line like this:

setup.exe /qb SAPWD=sa

On Wed, 25 Jan 2006 14:18:57 +0200, Daniel Crichton
<msnews(a)worldofspack.co.uk> wrote:

> Igor wrote on Tue, 24 Jan 2006 17:27:29 +0200:
>
>> SQL Server 2005 rejects empty or very short sa passwords. Where can i
>> read
>> formal definition of sa password rules. I writing setup application
>> which
>> will install SQL Server Express in command line unattended mode. So i
>> need
>> to check sa password for its stronginess prior to passing it to SQL
>> Server's installer.
>
> It only does this if you have enabled Password Complexity Policy. During
> install on my test server I had no trouble using the password sa for the
> sa
> account, as you have to explicitly enable the policy using ALTER LOGIN
> for
> each login.
>
> Dan
>
>

From: Daniel Crichton on 25 Jan 2006 08:31
Igor wrote on Wed, 25 Jan 2006 14:30:56 +0200:

> Do you run SQL Server installer from command line like this:
>
> setup.exe /qb SAPWD=sa

No, I ran the GUI installer. I could see no mention of password policy
checking in the BOL for command line installer so assumed that it works the
same way. As you're asking that question I assume that it doesn't work.

Dan


First  |  Prev  | 
Pages: 1 2 3
Prev: SQL 2005 Mirroring Databases
Next: Unmanaged code from SQLServer 2005 CLR