Search code examples
sql-server-2008r2-express

How to Install SQL Server 2008 R2 Configuration Manager


I'm trying to install SQL Server 2008 R2 Express with SP2 from a command line.

Everything works fine, but the Configuration Manager is not being installed.

The file I'm using is SQLEXPRWT_x64_ENU.exe

the command line is

sqlexprwt_x64_ENU /q /hideconsole /action=Install /features=SQL 
      /instancename=SQLEXPRESS /enableranu=1 
      /sqlsvcaccount=NT Authority\System /AddCurrentUserAsSqlAdmin 
      /skiprules=RebootRequiredCheck /IAcceptSQLServerLicenseTerms 
      /securitymode=SQL /sapwd=XXXXXXX /tcpenabled=1 
      /sqlsvcstartuptype=Automatic /browsersvcstartuptype=Automatic

I've also tried /features=SQL,TOOLS without success.

A manual install installs Config Manager and SSMS etc etc. so it can be done; but not from a command line apparently.

What am I doing wrong?

EDIT to expand on dvdd's answer: the SSMS parameter to Features was the missing ingredient. Given its name, I had assumed (yes, I know) that it installed SSMS; but in fact it has the effect of installing Config Manager even when not installing using the 'wt' version of the exe.


Solution

  • My production deployments include the install parameter /features=SQLENGINE,SSMS to accomplish this task.