cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pulsar
Level 4

SQL Server 2008 - do we require Windows Powershell?

Hi,
We have successfully installed SQL Server 2008 via Windows Powershell, but now need to replicate this on InstallShield Express.

The following appears to work using Windows Powershell:

"D:\4 - SQLEXPRWT_x86_ENU.exe" /INSTANCENAME="SQLEXPRESS2" /ACTION="Install" /FEATURES=SQLENGINE,SSMS /HELP="False" /INDICATEPROGRESS="False" /QUIETSIMPLE="True" /X86="True" /ERRORREPORTING="False" /SQMREPORTING="False" /SQLSVCSTARTUPTYPE="Automatic" /FILESTREAMLEVEL="0" /ENABLERANU="True" /SQLCOLLATION="Latin1_General_CI_AS" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /SECURITYMODE="SQL" /ADDCURRENTUSERASSQLADMIN="True" /TCPENABLED="1" /NPENABLED="0" /SAPWD="qwerty123"


How do we add this onto the .prq file, or do we need to add Windows Powershell to the installation?

We only have a few days left of the evaluation so I would really appreciate help with this from anyone who has successfully silently installed SQL Server 2008 express using InstallShield 2009 Express.

Thanks,
Labels (1)
0 Kudos
(6) Replies
KodeKrazy
Level 3

YES! You can install SQL Server 2008 Express via a .prq file;

Open your Prerequisite Editor and create a new name for it.

Add SQLEXPRWT_x86_ENU.exe to the "Files To Include" tab.

Also add SQLEXPRWT_x86_ENU.exe to the "Application to Run" tab in the "Specify the application you wish to launch:" text box.

Add

/q /INSTANCENAME="SQLEXPRESS2" /ACTION="Install" /FEATURES=SQLENGINE,SSMS /HELP="False" /INDICATEPROGRESS="False" /QUIETSIMPLE="True" /X86="True" /ERRORREPORTING="False" /SQMREPORTING="False" /SQLSVCSTARTUPTYPE="Automatic" /FILESTREAMLEVEL="0" /ENABLERANU="True" /SQLCOLLATION="Latin1_General_CI_AS" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /SECURITYMODE="SQL" /ADDCURRENTUSERASSQLADMIN="True" /TCPENABLED="1" /NPENABLED="0" /SAPWD="qwerty123"

To the "Specify the command line for the application:" text box

Add HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100
to the "Conditions" tab and set it to install if "Registry Key Does NOT exist"

Then save it and reference it in your "Redistributables View"

That's it! It worked for me.

Cheers!

KK
0 Kudos
malhabibi
Level 2

Hi,

SQL Server 2008 Express needs

DotNet 3.5 sp1
Windows Shell Script
Windows Installer 4.5

can we add all these as a pre requsites just like you did with sql express?

Thanks
0 Kudos
KodeKrazy
Level 3

Yes, but make sure you use the FULL version of the dotnetfx35.exe (it's HUGE!) but when we tried using the .prq files with the M$ "Bootstrappers" we were unsuccessful till we used the FULL version of the .NET Framework 3.5 SP1. You can download it at http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe

The 4.5 Win Installer .prq that comes with ISX09 works fine for getting that installed. As well as the WSH MM. Make sure you edit Prerequisite Order so that the prerequisites for SQLX08 get installed first or you will have problems. We just put SQL on the bottom of the list, and it installed 350 machines in less than a week for us!

If you have any other questions, let me know.

KK
0 Kudos
malhabibi
Level 2

Thank you very much for reply,

SQL Server 2008 always tell that Windows Shell is not installed

Please send me the order of installing prereuisites and switches given to the setup files for quiet installation

by the way a reboot is required in the middle of the installation
how to override this issue

Thanks in advance
0 Kudos
wrun44
Level 4

Hi,

Do you also install SQL 2008 Management Studio? Does it really require PowerShell?


Thank you.
0 Kudos
oghenez
Level 3

wrun44 wrote:
Hi,

Do you also install SQL 2008 Management Studio? Does it really require PowerShell?


Thank you.


yes, you have to in winxp
0 Kudos