Hi Shabbir, Try changing the following Command node of "package.xml" located at "C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\SqlExpress\en":
<Command PackageFile="sqlexpr32.exe" Arguments='-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1' EstimatedInstalledBytes="225000000" EstimatedTempBytes="225000000" EstimatedInstallSeconds="420"> change the arguments attribute to allow mixed mode authentication. hope this helps. Regards, Asiri Wanigarathne On 19 March 2010 02:23, Shabbir Ahsan <shabbir_ah...@hotmail.com> wrote: > > HI, > > > > I have included SQL server 2005 express via the bootstrapper on my install. > The problem I am getting is when the installation is complete, I find the > website installed cannot connect to the DB and neither cna the windows > service. The reason being that the server has been installed with the > default windows authentication. I then have to download SQL management > studio and then enable SQL Server and Windows authentication mode. > > > > The question is, can I not set this at install time, so everything just > works out of the box. I have looked at SQL scripts, and they just return in > errors. I have found that a command can be used when installing, but how > can this be included with the bootstrapper? > > > > Thanks > > > > _________________________________________________________________ > We want to hear all your funny, exciting and crazy Hotmail stories. Tell us > now > http://clk.atdmt.com/UKM/go/195013117/direct/01/ > > ------------------------------------------------------------------------------ > Download IntelĀ® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users