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 <[email protected]> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users