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