admin1.552489617261148E12 asked a question.
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,
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
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
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
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
Do you also install SQL 2008 Management Studio? Does it really require PowerShell?
Thank you.
Hi,
Do you also install SQL 2008 Management Studio? Does it really require PowerShell?
Thank you. "
yes, you have to in winxp