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
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- Solution
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
Feb 20, 2012
04:51 PM
Install SQL Express 2008 R2 (64 Bit) - Best Practices?
Install Platform:
Server 2008 R2
InstallAnywhere 2011 Enterprise
Greetings:
I have the following requirement to install SQL Server Express R2 as a per-requisite to a web app and service I am installing.
MS SQL Server Express 2008 R2 (64 Bit)
Current file is SQLEXPRWT_x64_ENU.exe
Instance Configuration: No change, s/b named instance and ID is SQLExpress with default path
Server Configuration: Set SQL Server Database Engine "Account Name" to NT AUTHORITY\SYSTEM and set SQL Browser startup type to automatic
Database Engine Configuration:
Set Authentication Mode to Mixed
I have tried to use "Execute Target File" with the appropriate switches but nothing happened and no useful log information was created.
I need to install the database server, set it as a Host and run a MS SQL script against it. What are the best practices for doing this??
The product documentation and forums are VERY WEAK when it comes to Advanced Installer topics.
Thanks!
Ryan
Server 2008 R2
InstallAnywhere 2011 Enterprise
Greetings:
I have the following requirement to install SQL Server Express R2 as a per-requisite to a web app and service I am installing.
MS SQL Server Express 2008 R2 (64 Bit)
Current file is SQLEXPRWT_x64_ENU.exe
Instance Configuration: No change, s/b named instance and ID is SQLExpress with default path
Server Configuration: Set SQL Server Database Engine "Account Name" to NT AUTHORITY\SYSTEM and set SQL Browser startup type to automatic
Database Engine Configuration:
Set Authentication Mode to Mixed
I have tried to use "Execute Target File" with the appropriate switches but nothing happened and no useful log information was created.
I need to install the database server, set it as a Host and run a MS SQL script against it. What are the best practices for doing this??
The product documentation and forums are VERY WEAK when it comes to Advanced Installer topics.
Thanks!
Ryan
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Feb 21, 2012
05:48 PM
Although it may not be ideal, here is the solution I came up with. It gives you granular control over the SQL Express install.
The SQL install file is packed with our installation then the Setup folder is deleted after. To install SQL Express
Step 1:
Add a new "Execute Script" task.. named "Unpack SQL Express".
Specify this command:
$USER_INSTALL_DIR$$/$SQLEXPRWT_x64_ENU.exe /extract: "c:\temp\sql" /q
This will unpack all the setup files and allow you to execute all the switches (or config file) against the SQL Express setup.exe file.
Step 2:
Add a new "Execute Script" task.. named "Install SQL Express".
Specify this command:
C:\temp\sql\Setup.exe /qs /HIDECONSOLE /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLExpress /ADDCURRENTUSERASSQLADMIN /IACCEPTSQLSERVERLICENSETERMS
The SQL install file is packed with our installation then the Setup folder is deleted after. To install SQL Express
Step 1:
Add a new "Execute Script" task.. named "Unpack SQL Express".
Specify this command:
$USER_INSTALL_DIR$$/$SQLEXPRWT_x64_ENU.exe /extract: "c:\temp\sql" /q
This will unpack all the setup files and allow you to execute all the switches (or config file) against the SQL Express setup.exe file.
Step 2:
Add a new "Execute Script" task.. named "Install SQL Express".
Specify this command:
C:\temp\sql\Setup.exe /qs /HIDECONSOLE /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLExpress /ADDCURRENTUSERASSQLADMIN /IACCEPTSQLSERVERLICENSETERMS
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)