Friday, August 10, 2012

Upgrade SQL Server 2008 r2 Express instance to SQL Server 2008 r2 Enterprise

For one of my SharePoint 2010 Setups , I wanted to upgrade one of the SQL Server 2008 R2 Express Edition instances to SQL Server 2008 R2 Enterprise Edition. Since my setup already had SQL Server 2008 R2 Enterprise Edition installed, I only needed to go through the following steps to upgrade the specific instance.

When reviewing the properties of the instance with SQL Server Management Studio, it showed the Product version as SQL Server Express Edition.


ok Lets Start the Upgrade Process:

>> In the Start menu, under Microsoft SQL Server 2008 R2, open the SQL Server Installation Center in the Configuration Tools folder. 









>> Then, under Installation, click Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008

  Install Setup Supported files:

 >> You may be prompted to browse for the SQL Server 2008 R2 installation media to install the Setup Support files. you can give reference to iso, dvd drive or the local drive in which you stored the setup file of SQL Server 2008 R2.

















>> Make sure the Setup Support Rules pass before continuing on.
























>>  


>> Run the Install.

























Upgrade the Express Instance:  

>> 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. 




























>>  Next, 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. 

>> After running the updates, you can also see the instance's build version through the SQL Server Management Studio. 


 After these steps, I ran the SharePoint Products Configuration Wizard to bring everything up to date.

Hurray you are done !!

Regards,
Viral Shah

Contact me

Name

Email *

Message *

Total Pageviews