In order to add features from the full version of SQL Server 2008 R2 to the Express version.

Get a hold of the full version DVD or installation media, then use the following command from the command prompt;

setup.exe /FEATURES=Tools /Q  /INDICATEPROGRESS  /ACTION=Install /INSTANCENAME=UPSTAIRSSQLEXPRESS /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT=”NT AUTHORITYNETWORK SERVICE”  /IACCEPTSQLSERVERLICENSETERMS

By |2015-02-25T13:47:30+00:00May 28th, 2012|SQL Server|2 Comments

About the Author:

2 Comments

  1. Steve Tomlinson July 18, 2012 at 9:48 pm

    Aha! That’s how you do it!
    Does that apply to the workgroup edition as well as the standard edition?

  2. Pete Gallagher July 31, 2012 at 1:40 pm

    Thanks for the comment Steve…. I believe this applies to any edition of SQL Server 2008 R2.

Leave A Comment

ABOUT US

PJG Creations creates bespoke desktop and web applications for companies across the country.

Specialising in converting outdated paper based or legacy software systems, to modern, database driven, process led applications.

Toggle Sliding Bar Area