27.8 C
Dubai
Friday, December 2, 2022

SQL 2008 R2 In place Upgrade to SQL 2014

I have a SCCM Database server running Windows Server 2012 R2 with SQL 2008 R2 . Which doesn’t allow SCCM upgrades any more . Unless the SQL Server is 2014 SP2 or later.

Checking the edition . It was SQL 2008 R2 Standard in the existing server. Have Download SQL 2014 Standard setup and SQL 2014 SP2 setup separately. Note that we can download SQL 2014 Server with SP2 rather than doing it separately . but I haven’t tested myself.

First. Take Full SQL backup of the existing databases for recovery purposes.

image

Stop below services and set to Manual

  • SMS Agent Host
  • SMS_Executive
  • SMS_SITE_SQL_BACKUP_SERVERNAME

image

In my Case I have taken a snapshot as its on VMware. and Turned of my SCCM server so that no database activity in place.

  • Uninstalled SQL Server 2012 Native Client from Add/remove programs.

image

 

Now Run SQL Upgrade from 2008 R2 to SQL 2014

image

Next | Next | Next with all Default Options upgrading the SQL Instance.

image

Rebooted the server

Ran SQL Server 2014 Service Pack 2

image

Rebooted the server

Now go to Add or remove programs remove SQL 2008 R2 Server

image

Reboot the server.

Now start the services  and set to Automatic.

image

Start your SCCM Server . Console works Good. All services came back to normal.

Now Upgraded SCCM to 1702. It upgraded successfully.

image

Satheshwaran Manoharan
Satheshwaran Manoharanhttps://www.azure365pro.com
Specialized in Microsoft Azure - Office 365 / Microsoft Exchange; conducted numerous projects worldwide in designing, supporting, and implementing messaging and virtualization infrastructure for medium-sized and large enterprises. Further, I am a Cloud Architect and Technical Advisor for various start-ups.

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

× How can I help you?