PDA

View Full Version : Setup Prereqs



sabinj
05-25-2010, 01:02 PM
I am trying find documentation on the Condition Type properties in the .prq files.

I am attempting to install SQL Express 2005 SP2 with my application as it is required. I need it to install even if there is an existing installation of SQL express because my application requires a specific instance name for SQL.

So, the prereq must install regardless if there is another instance of SQL express. The install must support a named instance. Here is the contents of my PRQ files for SQL Express 2005 SP2.

--------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<SetupPrereq>
<conditions>
<condition Type="32" Comparison="2" Path="HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion" FileName="CurrentVersion" ReturnValue="9.00.3042.00"></condition>
</conditions>
<files>
<file LocalFile="&lt;ISProductFolder&gt;\Objects\SQL2005ExpressSP2\SQLEXPR32.EXE" URL="http://saturn.installshield.com/devstudio/setuprequirements/sqlexpress/sp2/SQLEXPR32.EXE" CheckSum="CC50972311E47C2166B3FEEC0675211F" FileSize="0,38220656"></file>
</files>
<execute file="SQLEXPR32.EXE" cmdline=" /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components SECURITYMODE=SQL INSTANCENAME=MYINSTANCE SAPWD=passwd; DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1" requiresmsiengine="1"></execute>
<properties Id="Microsoft SQL Server 2005 Express SP2" Description="This installs Microsoft SQL Server 2005 Express Edition SP2 (SQL Server Express). The /qn switch suppresses all Setup dialog boxes and error messages. See http://msdn2.microsoft.com/en-us/library/ms144259.aspx for more information about the commad line options." AltPrqURL="http://saturn.installshield.com/devstudio/setuprequirements/sqlexpress/sp2/121208/microsoft sql server 2005 express sp2.prq"></properties>
</SetupPrereq>
--------------------------------------------------------------------------