InstallAware 10 - Does it install MS SQL 08 Exp & Adv Srvcs?

[DennisDawg]

I have InstallAware 10. Based on the choices presented in this URL:

http://www.microsoft.com/express/Databa ... tions.aspx

Which version of MS SQL 2008 Express R2 does InstallAware install when MS SQL 2008 Express R2 (x64 and/or x32) are selected in the Application Run Times (1. Database, 2. Database with Management Tools or 3. Database with Advanced Services)?

Is there a simple and documented way to install Database with Advanced Services?

Please note, this is basically a question asking about Advanced Services, not x63 vs x32 . . .

Thank you.

[mills]

The provided runtime should provide the full package, you just need to specify which features you want available.

In the design view, with the Microsoft SQL Server Express 2008 R2 runtime selected, click the Options button.
Click OK on the check service prompt.
On (the second) Set Variable prompt, you can specify what features are installed (its easiest to copy/past and edit in notepad):

Code: Select all

/q /ACTION=Install /SECURITYMODE=SQL /SAPWD="Sq1S#rv$r" /INSTANCENAME="SQLEXPRESS" /FEATURES=SQLEngine,Replication,SDK,Tools /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="$SQL_COMPUTER_NAME$\$SQL_USER_NAME$" /IAcceptSQLServerLicenseTerms=TRUE

See this for more details on customizing the setup:
http://technet.microsoft.com/en-us/libr ... px#Feature

If you find that the features you desire aren't available, you can request them, but you can add them yourself, as detailed in the Extending Runtimes View whitepaper:
http://installaware.com/publications-whitepapers.htm

[DennisDawg]

Unfortunately “should provide the full package” does not answer my question as well as I need.

All of them are “full packages,” 1. Database, 2. Database with Management Tools or 3. Database with Advanced Services are all complete. What I need to know is which of the three, 1, 2 or 3 is actually used by InstallAware’s Application Runtime feature. There are three versions of MS SQL Server Express R2. Your documentation should indicate which of the three is available in the Application Runtime your provide but It does not.

I need to know for sure what the version your application is trying to install is so I know how to design the install for our product which needs Advanced Services.

Can you please check which (1,2 or 3) is included with your products feature?

Can you please verify that InstallAware will install Advanced Services for both 32 and 64 bit versions of SQL Server Express 2008 R2 that are installed as Runtimes via the products User Interface by InstallAware?

Thank you.

[mills]

It's the Database. The provided runtimes include:

Instance Features
- Database Engine Services
- SQL Server Replication

Share Features
- SQL Client Connectivity SDK

[DennisDawg]

OK, then just to be 100% clear for me and anyone who comes after, of the three: 1. Database, 2. Database with Management Tools or 3. Database with Advanced Services are all complete. Install Aware only handles #1.

Therefore, InstallAware's Runtime support does not install Database with Advanced Services, #3. And, the information about “/FEATURES=SQLEngine,Replication,SDK,Tools” is erroneous in regard to Database with Advanced Services, #3.

No #3 via InstallAware's built in support . . .

If this is incorrect, please let me know.