UPGRADE SQL SERVER EXPRESS INSTANCE TO SQL SERVER ENTERPRISE

  • – In the Start menu, under Microsoft SQL Server 2008 R2, open the SQL Server Installation Center in the Configuration Tools folder.
  • – Under Installation, click Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008.
  • – You may be prompted to browse for the SQL Server 2008 R2 installation media to install the Setup Support files. In my case, I mounted the ISO.
  • Make sure the Setup Support Rules pass before continuing on.
  • Run the install
  • After the install is complete, you can now continue with the process to upgrade the Express instance.
  • Again, make sure the Setup Support Rules all pass before continuing on.
  • The setup should find your existing product key. If not, enter it now.
  • Accept the license terms
  • Select the SQL instance to upgrade. In my case, the name of the Express instance was “SHAREPOINT”.
  • The installer will preselect the features to be upgraded in the instance.
  • Verify the Instance ID and root directory, and continue on.
  • Verify you have enough drive space, and click Next.
  • Decide if you want to turn on error reporting, and click Next.
  • Verify the Upgrade Rules all pass before continuing on.
  • The installer will provide a summary of the upgrade actions. Click Upgrade.
  • After the installer finishing the upgrade, it will provide a confirmation page that the instance was successfully upgraded.
  • When reviewing the properties of the SQL instance in the SQL Server Management Studio, it will now show that it has been upgraded to SQL Server Enterprise Edition.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s