Friday, June 1, 2012

Upgrading a SQL Server 2008 Express installation to SQL Server 2012 Express

If you have previously installed SQL Server 2008 Express (just the database engine) that is often included with  installations (such as Visual Studio 2010 and SharePoint 2010), and attempt to upgrade to SQL Server 2012, you will encounter the following error message:

Therefore, you will have to install SQL 2008 SP2 or later (current release is SP3) before you can upgrade to SQL 2012.  You can download SQL 2008 SP3 from here:

Therefore, after installing SQL 2008 SP3, you can then proceed with the SQL Server 2012 installation.

Since I was performing an upgrade from SQL 2008 SP3 to SQL 2012, I naturally chose the Upgrade option in the SQL 2012 Dialog even though I was installing SQL 2012 with Tools.

Unfortunately, however, the Upgrade is simply that--an UPGRADE.  Therefore, ONLY the Database Engine is upgraded and the tools are not installed.

After the database engine was upgraded, I then had to re-run the SQL Server 2012 with Tools installation and instead choose the "New SQL Server stand-alone installation or add features to an existing installation" option.

After choosing this option, I was finally able to choose the installation of the Management Tools as well as install LocalDB.

No comments:

Post a Comment