View Full Version : Sqlexpress 2005 .prq question

08-18-2010, 02:47 PM
Is it possible to make adjustments to the "Microsoft SQL Server 2005 Express SP2.prq" file in the C:\Program Files\InstallShield\2010\SetupPrerequisites folder.

I can get the following to work if I run via a batch file with the exact same switches.

When I adjust the .prq file, I don't receive any compile errors, but it just bombs out during the sql install when the setup runs.

I tried using the same switches to call SQLEXPR32.exe under the custom section after file downloads, but that doesn't compile correctly.

Am I missing something, or is this not possible.
I'm just trying to rename the sql instance and run silent ( doesn't matter if I see it on screen or not).

This is what I've done in the prq.

<execute file="SQLEXPR32.EXE-qb /norebootchk /qb reboot=ReallySuppress addlocal=all instancename=Server3" requiresmsiengine="1"></execute>

08-18-2010, 03:44 PM
hmm...think i just figured it out.

After looking at some other posts, I found I needed to leave the SQLEXPR32.exe in it's own quotes, then put cmdline= before the arguments.

For example:

<execute file="SQLEXPR32.EXE" cmdline="-qb /norebootchk /qb reboot=ReallySuppress addlocal=all instancename=MyInstance SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=2 SQLAUTOSTART=1 requiresmsiengine=1"></execute>

Hope this helps someone else out.