I am trying to find documentation regarding the Condition Type properties in the prq files. I need to know what condition will require SQL Server Express 2005 SP2 to be installed with the instance name I specified regardless if another instance of SQL is already installed. My Application a specific instance name to function properly. Below is the contents of my prq files for sql express. --------------------------------------------------------------------------
You cannot have two SQL Server instances with the same name on the one machine. Therefore you should check whether 'MYinstanceName' is already installed on the target machine and if it is, what is the version.
You can check this via registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MYinstanceName\MSSQLServer\CurrentVersion
Note that detecting sql server instances via registry in not recommended way of detecting SQL Server instances. The right way is to use WMI. However, AFAIK InstallShield does not provide possibility to create conditions based on output of the external app directly (unlike MS SQL Server bootstrapper). If you have MS Windows SDK installed on your system check boostrapper folder, in the SQL Server directory there is a small utility called SqlExpressChk.exe. This utility is used to checked for presence of the SQL Server on the target machine. It communicates with bootstrapper via exit codes. If you wanted to use WMI, you would like to write similar tool with your instance name (SDKs sql checker checks only for the 'SQLEXPRESS' name and is not configurable).
