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:
- Uninstall Reporting Services Point role. (Optional)
- Uninstall SQL Reporting services. (Optional)
- Remove/Delete SQL report server DB and log files. (Optional)
- Stop SCCM services.
- Upgrade SQL 2012 to 2016 SP1.
- Re-Install the SQL Reporting Services. (Optional)
- Configure the SQL Reporting Services. (Optional)
- Re-install Reporting Services Point role. (Optional)
- 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.