Monday 28 May 2012

Adding SQL Server 2008 R2 features to SQL Server Express

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=UPSTAIRS\SQLEXPRESS /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"  /IACCEPTSQLSERVERLICENSETERMS

Posted by at
Labels:

2 comments:

  1. Unknown18 July 2012 at 14:48

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

    ReplyDelete
  2. Pete Gallagher31 July 2012 at 06:40

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

    ReplyDelete

Subscribe to: Post Comments (Atom)