SQL 2016 upgrade for SCCM Server

In this post, I will show how to upgrade the SQL server of SCCM from 2012 S3 to 2016 SP1.

Requirements:

  • SCCM server with min SQL 2012 SP3
  • SQL Server 2016 SP1 installation media

The overall steps for upgrading the SQL:

  1. Uninstall Reporting Services Point role. (Optional)
  2. Uninstall SQL Reporting services. (Optional)
  3. Remove/Delete SQL report server DB and log files. (Optional)
  4. Stop SCCM services.
  5. Upgrade SQL 2012 to 2016 SP1.
  6. Re-Install the SQL Reporting Services. (Optional)
  7. Configure the SQL Reporting Services. (Optional)
  8. Re-install Reporting Services Point role. (Optional)
  9. Start SCCM services.

Since I have an issue with the Reporting Services, I will take the opportunity to re-install it as well. You can follow the same steps if you are willing to move the Reporting Services.

Uninstall Reporting Services Point role

Open the SCCM console and locate \Administration\Overview\Site Configuration\Servers and Site System Roles

Select the server that has the Reporting services point role. Right click and choose Remove.

Uninstall SQL Reporting services

Open Control Panel > Program and Features and uninstall SQL Server 2012. Select Remove.

Select the instance where the Reporting Services and then choose Reporting Services – Native.

Verify that you are uninstalling only the Reporting Services and continue with the rest of the screens.

Remove/Delete SQL report server DB and log files

Connect to the SQL server using SQL Management Studio and display the databases.

Right click on ReporServer and then ReportServerTempDB databases and choose Detach.

Select both check boxes and complete the task.

Remove/Delete SQL report server DB and log files

Locate the MS Reporting Server installation directory. Usually located under C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

Delete the ReportServer and ReportServerTempDB files and log files.

Stop SCCM services

Stop the below services in SCCM server.

Upgrade SQL 2012 to 2016 SP1

Locate the SQL 2016 SP1 media and start the upgrade.

Continue the screens without selecting anything.

After the upgrade completed, restart the server.

Re-Install the SQL Reporting Services

Use the same SQL 2016 installation media but this time choose Add options. Select Reporting Services (Native) from the features.

Keep the service account as it is.

You are only allowed to install without configuration. We will do the configuration later.

The installation will complete as below.

Configure the SQL Reporting Services

After the Reporting Services installation, now it is time to configure it, otherwise it will not work.

Open Reporting Services Configuration Manager and connect to the instance of Reporting Services.

On the Web Service URL section, click on Apply.

On the Database section, Click on Change Database and create a new database.

The new report server database will be created.

On the Web Portal URL section, click on Apply.

Exit the wizard.

Re-install Reporting Services Point role

Open the SCCM console and locate \Administration\Overview\Site Configuration\Servers and Site System Roles

Select the server that will have the Reporting services point role. Right click and choose Add Site System Roles.

Select the role from the list and complete the wizard.

That’s the end of this port.

Hope this will be helpful to someone out there.

Related Posts

SCCM Update Stuck Downloading State

In order to reset the stuck download of SCCM Service Update, first you need a copy of the update reset tool which comes within the SCCM download…

SCCM 1902 Upgrade

In-console upgrade of SCCM 1902 is available. As best practice, it is always recommended to run the prerequisite check before you install the upgrade directly. \Administration\Overview\Updates and…

SCCM Site Back-Up Failure

SCCM site back-up is one of the essential back op options. Even your environment is stable, you may receive alerts in smsbkup.log as below: Cannot find the…

SCCM 1810 Upgrade

In-console upgrade of SCCM 1810 is finally available. As best practice, it is always recommended to run the prerequisite check before you install the upgrade directly. The…

SCCM Reporting Database Log File Size

Reporting Server DB log file may increase dramatically in time in SCCM. If you dont take preventive actions, you may have service interruptions. Before you do any…

Windows 10 Servicing Update Failed

When you are upgrading Windows 10 using Servicing Feature in SCCM, you may get failure as below related to the incompatible software. Because the UI is not…