Enable mixed mode authentication during installation of sql server 2008 express as a prerequisite

Question

Sql Server 2008 Express when installed as a prerequisite in a Setup project in Visual Studio installs itself with Windows Authentication enabled.

How do we install it with Mixed Mode enabled?

I tried changing the package manifest as follows for the Command for PackageFile SQLEXPR32_x86_ENU.EXE and SQLEXPR_x64_ENU.EXE

Current set of Arguments:

/q /hideconsole /action=Install /features=SQL /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck

New set of Arguments:

Arguments="/q /hideconsole /action=Install /features=SQL /SECURITYMODE=SQL /SAPWD="Password123" /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck"

This failed and I got the following error message:

The following properties have been set:
Property: [AdminUser] = true {boolean}
Property: [InstallMode] = SameSite {string}
Property: [ProcessorArchitecture] = Intel {string}
Property: [VersionNT] = 5.1.3 {version}
Running checks for package 'Windows Installer 4.5', phase BuildList
Looking up path for special folder 'WindowsFolder'
Running check with folder 'C:\WINDOWS\System32' and file 'msi.dll'
Attempting to find file 'C:\WINDOWS\System32\msi.dll'
File version is '4.5.6001.22299'
Setting value '4.5.6001.22299 {version}' for property 'VersionMsiDll'
The following properties have been set for package 'Windows Installer 4.5':
Property: [VersionMsiDll] = 4.5.6001.22299 {version}
Running checks for command 'WindowsInstaller4_5\WindowsXP-KB942288-v3-x86.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '4.5': true
Result of checks for command 'WindowsInstaller4_5\WindowsXP-KB942288-v3-x86.exe' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\WindowsXP-KB958655-v2-x86-ENU.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsiDll' and value '4.5.6001.22299': true
Result of checks for command 'WindowsInstaller4_5\WindowsXP-KB958655-v2-x86-ENU.exe' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\WindowsServer2003-KB942288-v4-x86.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '4.5': true
Result of checks for command 'WindowsInstaller4_5\WindowsServer2003-KB942288-v4-x86.exe' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\WindowsServer2003-KB958655-v2-x86-ENU.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsiDll' and value '4.5.6001.22299': true
Result of checks for command 'WindowsInstaller4_5\WindowsServer2003-KB958655-v2-x86-ENU.exe' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\WindowsServer2003-KB942288-v4-x64.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '4.5': true
Result of checks for command 'WindowsInstaller4_5\WindowsServer2003-KB942288-v4-x64.exe' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\WindowsServer2003.WindowsXP-KB958655-v2-x64-ENU.exe'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsiDll' and value '4.5.6001.22299': true
Result of checks for command 'WindowsInstaller4_5\WindowsServer2003.WindowsXP-KB958655-v2-x64-ENU.exe' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\Windows6.0-KB958655-v2-x86.MSU'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsiDll' and value '4.5.6001.22308': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '6.0': true
Result of checks for command 'WindowsInstaller4_5\Windows6.0-KB958655-v2-x86.MSU' is 'Bypass'
Running checks for command 'WindowsInstaller4_5\Windows6.0-KB958655-v2-x64.MSU'
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsiDll' and value '4.5.6001.22308': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'amd64': true
Result of checks for command 'WindowsInstaller4_5\Windows6.0-KB958655-v2-x64.MSU' is 'Bypass'
'Windows Installer 4.5' RunCheck result: No Install Needed
Running checks for package 'Microsoft .NET Framework 4 (x86 and x64)', phase BuildList
Reading value 'Version' of registry key 'HKLM\Software\Microsoft\NET Framework Setup\NDP\v4\Full'
Read string value '4.0.30319'
Setting value '4.0.30319 {string}' for property 'DotNet40Full_TargetVersion'
The following properties have been set for package 'Microsoft .NET Framework 4 (x86 and x64)':
Property: [DotNet40Full_TargetVersion] = 4.0.30319 {string}
Running checks for command 'DotNetFX40\dotNetFx40_Full_x86_x64.exe'
Result of running operator 'ValueEqualTo' on property 'InstallMode' and value 'HomeSite': false
Result of running operator 'VersionGreaterThanOrEqualTo' on property 'DotNet40Full_TargetVersion' and value '4.0.30129': true
Result of checks for command 'DotNetFX40\dotNetFx40_Full_x86_x64.exe' is 'Bypass'
Running checks for command 'DotNetFX40\dotNetFx40_Full_setup.exe'
Result of running operator 'ValueNotEqualTo' on property 'InstallMode' and value 'HomeSite': true
Result of checks for command 'DotNetFX40\dotNetFx40_Full_setup.exe' is 'Bypass'
'Microsoft .NET Framework 4 (x86 and x64)' RunCheck result: No Install Needed
Running checks for package 'SQL Server 2008 Express', phase BuildList
Running external check with command 'C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\SqlExpress2008\SqlExpressChk.exe' and parameters '10.0.1600 1033'
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressChk'
The following properties have been set for package 'SQL Server 2008 Express':
Property: [SQLExpressChk] = 1 {int}
Running checks for command 'SqlExpress2008\SQLEXPR32_x86_ENU.EXE'
Result of running operator 'ValueNotExists' on property 'VersionNT': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value '5.2.0': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value '5.2.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-1': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-2': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-3': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-4': false
Result of running operator 'ValueLessThan' on property 'SQLExpressChk' and value '-4': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueNotEqualTo' on property 'SQLExpressChk' and value '1': false
Result of checks for command 'SqlExpress2008\SQLEXPR32_x86_ENU.EXE' is 'Install'
Running checks for command 'SqlExpress2008\SQLEXPR32_x86_ENU.EXE'
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueNotEqualTo' on property 'SQLExpressChk' and value '2': true
Result of checks for command 'SqlExpress2008\SQLEXPR32_x86_ENU.EXE' is 'Bypass'
Running checks for command 'SqlExpress2008\SQLEXPR_x64_ENU.EXE'
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'amd64': true
Result of checks for command 'SqlExpress2008\SQLEXPR_x64_ENU.EXE' is 'Bypass'
Running checks for command 'SqlExpress2008\SQLEXPR_x64_ENU.EXE'
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'amd64': true
Result of checks for command 'SqlExpress2008\SQLEXPR_x64_ENU.EXE' is 'Bypass'
'SQL Server 2008 Express' RunCheck result: Install Needed
EULA for components 'SQL Server 2008 Express' was accepted.
Copying files to temporary directory "C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\"
Copying from '<<ProjectFolder>>\Debug\SqlExpress2008\SQLEXPR32_x86_ENU.EXE' to 'C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\SqlExpress2008\SQLEXPR32_x86_ENU.EXE'
Verifying file integrity of C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\SqlExpress2008\SQLEXPR32_x86_ENU.EXE
WinVerifyTrust returned 0
File trusted
Running checks for package 'SQL Server 2008 Express', phase BeforePackage
Running external check with command 'C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\SqlExpress2008\SqlExpressChk.exe' and parameters '10.0.1600 1033'
Process exited with code 1
Setting value '1 {int}' for property 'SQLExpressChk'
The following properties have been set for package 'SQL Server 2008 Express':
Property: [SQLExpressChk] = 1 {int}
Running checks for command 'SqlExpress2008\SQLEXPR32_x86_ENU.EXE'
Result of running operator 'ValueNotExists' on property 'VersionNT': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1.2': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value '5.2.0': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value '5.2.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-1': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-2': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-3': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressChk' and value '-4': false
Result of running operator 'ValueLessThan' on property 'SQLExpressChk' and value '-4': false
Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueNotEqualTo' on property 'SQLExpressChk' and value '1': false
Result of checks for command 'SqlExpress2008\SQLEXPR32_x86_ENU.EXE' is 'Install'
'SQL Server 2008 Express' RunCheck result: Install Needed
Verifying file integrity of C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\SqlExpress2008\SQLEXPR32_x86_ENU.EXE
WinVerifyTrust returned 0
File trusted
Installing using command 'C:\DOCUME~1\rvenka\LOCALS~1\Temp\VSD3E9.tmp\SqlExpress2008\SQLEXPR32_x86_ENU.EXE' and parameters '/q /hideconsole /action=Install /features=SQL /SECURITYMODE=SQL /SAPWD="Password123" /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck'
Process exited with code -2068119551
Status of package 'SQL Server 2008 Express' after install is 'InstallFailed'

 

Answer 1

Hi Ranjith,

 

Yes. We could use this switch /SECURITYMODE to enable the Mixed Authentication mode during the installation, also we could use the configuration.ini file to enable this mode.

 

Based on this error message, it is hard to say the cause of SQL Server installation failure. However, your password is "Password123", it might be not strong enough to meet the SQL Server strong password policy:
 

    1. Does not contain all or part of the user's account name

    2. Is more than eight characters in length

    3. Combines letters, numbers, and symbol characters within the password

    4. Is not the name of a command, person, user, computer

 

I would like to suggest combine symbol characters within your password such as "Password01!" and then try to install again.

 

If this still not work, could you please post the detailed error log for us to a further troubleshoot? It is located at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log by default.

 

Reference might be helpful:

 

Embedding SQL Server 2008 Express in an Application

How to: Install SQL Server 2008 Using a Configuration File

 

 

Thanks,
Weilin Qiao

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 2

I changed the manifest in the Bootstrapper packages by adding the following:

/SECURITYMODE=SQL /features=SQL,Tools /SAPWD="SqlServer2008"

Then I build the installed based on the changed manifest and it worked!

 

Answer 3

 

Hi Ranjith,

 

Thank you for your update and glad to hear your problem has been solved. If there are any question related to SQL Server, please post it in this forum, we will be happy to assist you.

 

Thanks,
Weilin Qiao

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.