SQL Upgrade of Orchestrator Server

In this post, I will demonstrate the steps for in-place upgrade of the SQL server version of System Center Orchestrator from 2016 to 2019.

Orchestrator Version: 2019
Server OS Version: 2019
SQL Version: 2016 SP3

  1. Install Microsoft OLE DB Driver for SQL Server 2019.
  2. Stop Orchestrator services.
  3. Start the upgrade process from the SQL 2019 ISO.
  4. Install the latest SQL CU which is 18 at the time of writing this post.
  5. Install the latest SQL management studio if available.
  6. Start Orchestrator services.
  7. Open Runbook Designer to test.

Related Posts

Orchestrator 2019 Upgrade

In this post, I will demonstrate System Center Orchestrator upgrade from 1807 to 2019. Back up the Orchestrator database. Backup all Runbooks (Right click on Runbooks folder…

Moving Orchestrator Database

In this post, I will demonstrate the steps for moving the remote Orchestrator database to the local management server. Since SQL 2016 is out there, we can…

In-place OS Upgrade of Orchestrator

Since the EOL of Windows Server 2012 R2 has been announced, it is time to upgrade the OS of the System Center products to Server 2016. In this…

Get AC Unit Temperature with Orchestrator

The other day I was requested to develop an interface that displays the temperature of the Air Condition (AC) units. You may ask that how is this…

Service Manager Task ile Orchestrator Runbook Çalıştırmak

Service Manager, Task özelliği ile harici bir komutun çalıştırılmasına ve Work Item’lar üzerinde işlem yapılmasına olanak tanır. PowerShell komutları kolaylıkla çalıştırılabildiği gibi Orchestartor Runbook’lar da Service Manager’da…