Sunday , December 15 2019

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 Office Server and Services MVP , Publisher of Azure365pro.com. Specialized in Office365 / Microsoft Exchange / Virtualization , Sathesh is an Messaging Expert supporting/Designing/Deploying many medium size businesses to large enterprises when it comes to Corporate messaging and Virtualization Infrastructure

Check Also

Adding DNS Servers in All DHCP Scopes using PowerShell

To Get all Scopes – Open PowerShell – Run as Administrator Get-DhcpServerv4Scope To Check DNS …

Leave a Reply

Your email address will not be published.