title: Configuring the Package.xml for SQL Express ClickOnce Pre-Requisite install?
body: <p>I have a winform app being installed by ClickOnce and I need to be able to enable Remote Connections in sqlexpress by default.  </p>
  
  <p>Also, I need to make sure the local user has access to the SQL instance. How do I edit the manifest file?</p>
  
  <p>My app is a part of a Merge Replication topology.  I inherited the DAL and until I change it I cannot switch to SQL CE due to SProc's limitation's.  </p>
  
  <p>SQL Express is ClickOnce (able) and is a default in VS2008 as a prerequisite.</p>
  
  <p>Below is the Product.xml of the SQL Express Bootstrapper package.  How can I modify this to accomplish what I need?  Has anyone else had to modify this?  <a href="http://aspalliance.com/714_ClickOnce_Deployment_Customizing_SQL_Server_Express.2" rel="nofollow noreferrer">Here is an example of this</a>.</p>
  
  <pre><code>&lt;Command PackageFile="sqlexpr32.exe" Arguments="-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1" EstimatedInstalledBytes="225000000" EstimatedInstallSeconds="420"&gt;
  &lt;InstallConditions&gt;
   &lt;BypassIf Property="SQLExpressInstalled" Compare="ValueEqualTo" Value="0"/&gt;
   &lt;BypassIf Property="VersionNT" Compare="VersionLessThan" Value="5.1"/&gt;
   &lt;FailIf Property="AdminUser" Compare="ValueEqualTo" Value="false" String="AdminRequired"/&gt;
   &lt;FailIf Property="Version9x" Compare="ValueExists" String="InvalidPlatformXP"/&gt;
   &lt;FailIf Property="VersionNT" Compare="VersionLessThan" Value="5.1.2" String="InvalidPlatformXP"/&gt;
   &lt;FailIf Property="ProcessorArchitecture" Compare="ValueNotEqualTo" Value="Intel" String="InvalidPlatformArchitecture"/&gt;
   &lt;/InstallConditions&gt;
  &lt;ExitCodes&gt;
   &lt;ExitCode Value="0" Result="Success"/&gt;
   &lt;ExitCode Value="1641" Result="SuccessReboot"/&gt;
   &lt;ExitCode Value="3010" Result="SuccessReboot"/&gt;
   &lt;ExitCode Value="50037" Result="Fail" String="MissingMSXml"/&gt;
   &lt;ExitCode Value="50251" Result="Fail" String="MissingMSXml"/&gt;
   &lt;ExitCode Value="50198" Result="Fail" String="InsufficientHardware"/&gt;
   &lt;ExitCode Value="50236" Result="Fail" String="InsufficientHardware"/&gt;
   &lt;ExitCode Value="50222" Result="Fail" String="InvalidPlatformOSServicePacks"/&gt;
   &lt;ExitCode Value="70003" Result="Fail" String="InvalidPlatformOSServicePacks"/&gt;
   &lt;ExitCode Value="50247" Result="Fail" String="InvalidPlatformIE"/&gt;
   &lt;ExitCode Value="50248" Result="Fail" String="InvalidPlatformIE"/&gt;
   &lt;ExitCode Value="70004" Result="Fail" String="AnotherInstanceRunning"/&gt;
   &lt;ExitCode Value="70032" Result="Fail" String="BetaComponentsFailure"/&gt;
   &lt;ExitCode Value="70033" Result="Fail" String="InvalidPlatformArchitecture"/&gt;
   &lt;DefaultExitCode Result="Fail" FormatMessageFromSystem="true" String="GeneralFailure"/&gt;
   &lt;/ExitCodes&gt;
   &lt;/Command&gt;
  </code></pre>
  
  <p>I thank everyone for there time.</p>