This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Sql server installation through install shield
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 09, 2015
06:49 AM
Sql server installation through install shield
Hi..,
Is there any way to install sql server 2012 through install shield setup??
Is there any way to install sql server 2012 through install shield setup??
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 11, 2015
09:20 AM
You may want to use the Microsoft SQL Server 2012 Express prerequisite included in the Redistributables view. Refer to the Adding InstallShield Prerequisites, Merge Modules, and Objects to Projects help topic on how to add prerequisites to your InstallShield project.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 11, 2015
10:21 PM
HI,
I tried this..Added Microsoft sqlserver 2012 sp1(x64). But when I installed the setup in another system, It first showed that pending sql server installation. after that the user have to follow & tick so many instructions. after that the set up is hanging. How can I correct this problem.?
I tried this..Added Microsoft sqlserver 2012 sp1(x64). But when I installed the setup in another system, It first showed that pending sql server installation. after that the user have to follow & tick so many instructions. after that the set up is hanging. How can I correct this problem.?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 12, 2015
10:56 AM
Anjali,
Are you adding Microsoft SQL Server 2012 Express SP1 as a feature prerequisite or a system prerequisite?
IF you are adding it as a feature prerequisite there is a known issue where Microsoft restarts the MSI engine after it checks for compatibility. This causes your installer to loose connection to the MSI handle and leads to the hangup you described.
As to the many pop-up commands and such, this is something you have to configure within the Prerequisite editor for SQL Server.
For instance the stock PRQ file from InstallShield assumes you are creating a default instance name, MSSQLSERVER. Many companies, such as mine, use a custom name, e.g., AMAZINGCHARTS, XMAP, MYFABULOUSCOMPANY, etc.
You will want to review the settings available to you from Microsoft for installing SQL Server on the command line. For instance you can set the command line parameters in the PRQ to use /QS for a silent install with a progress bar. This will not show any options for the UI.
Here is an example command line that I use for deploying SQL Server 2012 Express SP1.
Notice that I specify the INSTANCENAME, TCPENABLED, SAPWD, SECURITYMODE, etc.
Also note that I had to use a Suite / Advanced UI project type. The reason is that I wanted a singular setup where installing SQL Server was optional. The basic MSI project type does not allow for this without running into the hung install problem.
Hopefully this helps.
EDIT: Here is a link to the command line options for SQL Server. https://msdn.microsoft.com/en-us/library/ms144259%28v=sql.110%29.aspx
Are you adding Microsoft SQL Server 2012 Express SP1 as a feature prerequisite or a system prerequisite?
IF you are adding it as a feature prerequisite there is a known issue where Microsoft restarts the MSI engine after it checks for compatibility. This causes your installer to loose connection to the MSI handle and leads to the hangup you described.
As to the many pop-up commands and such, this is something you have to configure within the Prerequisite editor for SQL Server.
For instance the stock PRQ file from InstallShield assumes you are creating a default instance name, MSSQLSERVER. Many companies, such as mine, use a custom name, e.g., AMAZINGCHARTS, XMAP, MYFABULOUSCOMPANY, etc.
You will want to review the settings available to you from Microsoft for installing SQL Server on the command line. For instance you can set the command line parameters in the PRQ to use /QS for a silent install with a progress bar. This will not show any options for the UI.
Here is an example command line that I use for deploying SQL Server 2012 Express SP1.
/QS /ACTION=Install /HIDECONSOLE /INSTANCENAME=AMAZINGCHARTS /FEATURES=SQLENGINE /SQLSVCSTARTUPTYPE=Automatic /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /INDICATEPROGRESS /IACCEPTSQLSERVERLICENSETERMS /TCPENABLED=1 /NPENABLED=1 /SQLSYSADMINACCOUNTS=BUILTIN\Administrators /BROWSERSVCSTARTUPTYPE=Automatic /ASSYSADMINACCOUNTS=BUILTIN\Administrators /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SECURITYMODE=SQL /ASCOLLATION=SQL_Latin1_General_CP1_CI_AS /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /SAPWD=t6mp5Install0Pwd /ADDCURRENTUSERASSQLADMIN=false
Notice that I specify the INSTANCENAME, TCPENABLED, SAPWD, SECURITYMODE, etc.
Also note that I had to use a Suite / Advanced UI project type. The reason is that I wanted a singular setup where installing SQL Server was optional. The basic MSI project type does not allow for this without running into the hung install problem.
Hopefully this helps.
EDIT: Here is a link to the command line options for SQL Server. https://msdn.microsoft.com/en-us/library/ms144259%28v=sql.110%29.aspx
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)