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.
Stop below services and set to Manual
- SMS Agent Host
- SMS_Executive
- SMS_SITE_SQL_BACKUP_SERVERNAME
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.
Now Run SQL Upgrade from 2008 R2 to SQL 2014
Next | Next | Next with all Default Options upgrading the SQL Instance.
Rebooted the server
Ran SQL Server 2014 Service Pack 2
Rebooted the server
Now go to Add or remove programs remove SQL 2008 R2 Server
Reboot the server.
Now start the services and set to Automatic.
Start your SCCM Server . Console works Good. All services came back to normal.
Now Upgraded SCCM to 1702. It upgraded successfully.
