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