Silent Install of SQL Server Express 2012 from Inno Setup

sql-server-2012 installation inno-setup sql-server-2012-express
JasonMcF picture JasonMcF · Oct 18, 2013 · Viewed 7.8k times · Source

I am trying to install SQL Server Express 2012 silently from my application installer created using Inno Setup. When running the following command from the command line, SQL Server Express 2012 is installed as I want only showing progress of the install but not allowing the user to enter any input.

Command line command that works:

C:\Users\Jason\Desktop>SQLEXPR_x86_ENU.exe /ACTION=Install /INSTANCENAME=MYINSTANCE /INSTANCEID=MYINSTANCE /QS /HIDECONSOLE /INDICATEPROGRESS="False" /IAcceptSQLServerLicenseTerms /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="builtin\administrators" /SKIPRULES="RebootRequiredCheck"

In order to do this from my Inno Setup script I have the following code:

Exec(installName,
  '/ACTION=Install /INSTANCENAME=MYINSTANCE /INSTANCEID=MYINSTANCE /QS /HIDECONSOLE /INDICATEPROGRESS="False" /IAcceptSQLServerLicenseTerms /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="builtin\administrators" /SKIPRULES="RebootRequiredCheck"',
  '',
  SW_SHOW,
  ewWaitUntilTerminated,
  ResultCode);

where installName = SQLEXPR_x86_ENU.exe

When run from the Installer the SQL Server Express 2012 installer starts but after the first information dialog it then shows the SQL Server Installation Center window and the user has to select the type of installation before the installer continues. They also have to agree to the license agreement which was not required when running directly from the command line.

Any ideas on how to run the installer silently from Inno Setup?

Answer

Peter Chen picture Peter Chen · Nov 13, 2013

change from "BUILTIN\Administrators" to "BUILTIN\Users" will be fine.

Related questions

SQL Server 2012 can't start because of a login failure

I recently installed Microsoft SQL Server 2012 on a fresh Windows 7 installation, but whenever I want to run the server, I get the following error: Error 1069: The service did not start due to a logon failure. The following user is configured …

Read More
LocalDB deployment on client PC

I am very intrigued by this new version of SQL Server Express. It's not clear (to me) what a setup program should do to deploy an application that use a LocalDB. Is it required to install SQL Server Express on …

Read More
Install SQL Server 2012 with .Net Framework 4.5

I have a strange problem trying to install SQL Server 2012. I had a fresh copy of Windows Server 2008 R2. I installed Visual Studio 2012 on it, so the .Net Framework 4.5 installed on my Windows. When I want to install SQL Server 2012 …

Read More