Tuesday , December 18 2018

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

About Satheshwaran Manoharan

Satheshwaran Manoharan is an Microsoft Exchange Server MVP , Publisher of CareExchange.in
Supporting/Deploying/Designing Microsoft Exchange for some years.
Extensive experience on Microsoft Technologies.

Check Also

Anonymous Application relay connectors in Exchange 2016

Lets see how to create an Anonymous Application relay connectors in Exchange 2016. Every Application ...

Leave a Reply

Your email address will not be published.