Classification: Public
Hi Ravi,
This is how I am installing SQL Server Express 2012 in Burn/Bootstrapper:
<ExePackage Id="SQLExpressx64"
DisplayName="Microsoft® SQL Server® 2012 - Express Edition
x64"
SourceFile="..\PreReqs\SQLEXPR_x64_ENU.exe"
Name="RedistServerSA\SQLEXPR_x64_ENU.exe"
InstallCommand="/ACTION=Install /INSTANCENAME=SQLEXPRESS
/FEATURES=SQLENGINE /Q /HIDECONSOLE /SkipRules=RebootRequiredCheck
/IAcceptSQLServerLicenseTerms /SQLSVCSTARTUPTYPE=Automatic
/SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /AGTSVCACCOUNT="NT
AUTHORITY\NETWORK SERVICE" /ASSYSADMINACCOUNTS=BUILTIN\Administrators
/SQLSYSADMINACCOUNTS=BUILTIN\Administrators /BROWSERSVCSTARTUPTYPE=Disabled
/ADDCURRENTUSERASSQLADMIN=true /TCPENABLED=1"
InstallCondition="Not SqlInstanceFoundx64 AND Not
SqlInstanceFoundx64Express AND Not SqlInstanceFound AND Not
SqlInstanceFoundExpress AND VersionNT64"
DetectCondition="SqlInstanceFoundx64"
Cache="no"
Compressed="no"
PerMachine="yes"
Permanent="yes"/>
<ExePackage Id="SQLExpressx86"
DisplayName="Microsoft® SQL Server® 2012 - Express Edition
x86"
SourceFile="..\PreReqs\SQLEXPR_x86_ENU.exe"
Name="RedistServerSA\SQLEXPR_x86_ENU.exe"
InstallCommand="/ACTION=Install /INSTANCENAME=SQLEXPRESS
/FEATURES=SQLENGINE /Q /HIDECONSOLE /SkipRules=RebootRequiredCheck
/IAcceptSQLServerLicenseTerms /SQLSVCSTARTUPTYPE=Automatic
/SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /AGTSVCACCOUNT="NT
AUTHORITY\NETWORK SERVICE" /ASSYSADMINACCOUNTS=BUILTIN\Administrators
/SQLSYSADMINACCOUNTS=BUILTIN\Administrators /BROWSERSVCSTARTUPTYPE=Disabled
/ADDCURRENTUSERASSQLADMIN=true /TCPENABLED=1"
InstallCondition="Not SqlInstanceFound AND Not
SqlInstanceFoundExpress AND Not VersionNT64"
DetectCondition="SqlInstanceFound"
Cache="no"
Compressed="no"
PerMachine="yes"
Permanent="yes"/>
<!-- Check for SQL Server Express -->
<?define InstanceName = "MSSQLSERVER" ?>
<?define InstanceNameExpress = "SQLEXPRESS" ?>
<!-- Read SQL Server keys to find current instance and version -->
<!-- 32 bit OS search -->
<util:RegistrySearch
Id="SqlInstanceFound"
Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL" Value="$(var.InstanceName)"
Result="exists" Variable="SqlInstanceFound" />
<util:RegistrySearch
Id="SqlInstanceFoundExpress"
Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL" Value="$(var.InstanceNameExpress)"
Result="exists" Variable="SqlInstanceFoundExpress" />
<!-- 64 bit OS search -->
<util:RegistrySearch
Id="SqlInstanceFoundx64"
Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL" Value="$(var.InstanceName)" Win64="yes"
Result="exists" Variable="SqlInstanceFoundx64" />
<util:RegistrySearch
Id="SqlInstanceFoundx64Express"
Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL" Value="$(var.InstanceNameExpress)" Win64="yes"
Result="exists" Variable="SqlInstanceFoundx64Express" />
Steve
-----Original Message-----
From: Ravishankar [mailto:ravishankar.krishnasw...@idsnext.com]
Sent: April-19-13 1:10 AM
To: r...@robmensching.com
Cc: General discussion for Windows Installer XML toolset.
Subject: [WiX-users] Install SQL SERVER 2008 R2 Express
Hi Rob,
need your expertise :-)
My installer does a pre-check for SQL SERVER 2008 installation
<Condition Message="MS SQL Server not installed...Kindly install SQL
Server 2008 to continue with the installation">
<![CDATA[SQLSERVER >< SQLEXPRESS]]>
</Condition>
If SQL Server not found i need to invoke a *.bat file which has the silent
unattended installation SQL Server 2008 R2 Express which i have prepared
Please help me when and how i should execute the *.bat file
Thanks and Regards
Ravi
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced analytics on
semi-structured data. The platform includes APIs for building apps and a
phenomenal toolset for data science. Developers can use our toolset for easy
data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
This message has been marked as Public by Steven Ogilvie on April-19-13 8:43:18
AM.
The above classification labels were added to the message by TITUS Message
Classification.
For more information visit www.titus.com.
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
