Unable to install stored procedures for driver UpgradeCompatibilityLevel in the SolarWinds Platform

When running the Configuration Wizard, you may receive the error below:

ERROR:
Orion Database FAILED Database configuration failed:

•  Unable to install stored procedures for driver: UpgradeCompatibilityLevel

You will also find a similar error in the ConfigurationWizard.log files that are located in the C:\ProgramData\SolarWinds\Logs\Orion folder.

ERROR TaskAdapter - Error running task Orion.ConfigureDatabase Orion Database

System.InvalidOperationException: Unable to install stored procedures for driver: UpgradeCompatibilityLevel ---> System.Data.SqlClient.SqlException: Cannot drop the procedure 'UpgradeCompatibilityLevel', because it does not exist or you do not have permission.

• The account does not have permission to drop the Stored Procedure.
• The Stored Procedure is either corrupt, missing, or has a different procedure name other than "UpgradeCompatibilityLevel''

Important

You must have the necessary permissions to try either resolution.

Resolution 1: Use SQL Server Management Studio to manually change Upgrade Compatibility Level

1. Open SQL Server Management Studio to connect to the SQL Server.
2. Navigate to Object Explorer > Server and Databases. Expand Server and Databases.
3. Depending on the database type, either select a user database or expand System Databases to choose a system database.
4. Right-click on Database, and then click Properties. The Database Properties dialog box opens.
5. Click Options on the Select A page pane to view the current compatibility level in the Compatibility Level list box.
6. To change the compatibility level, select the desired option from the list. The available options are:
   SQL Server 2012 (110)
    SQL Server 2014 (120),
   SQL Server 2016 (130),
   SQL Server 2017 (140)
   SQL Server 2019 (150)
   SQL Server 2022 (160)
   SQL Server 2025 (170)

Note:

We no longer support upgrades to Windows Server 2008.

Resolution 2: Using SQL Server Management Studio to change the Upgrade compatibility using a query

1. Open SQL Server Management Studio and connect to the SQL Server.
2. Expand Databases and then right-click on SolarWinds Platform database.
3. Select New Query. A query window will appear on the right.
4. Paste the below query into the window and click Execute.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

ALTER DATABASE SolarWindsOrion SET COMPATIBILITY_LEVEL = {170 | 160 | 150 | 140 | 130 | 120 | 110}

5. Run the Configuration Wizard again to connect to the database.

Note:

The compatibility level will depend on the SQL server. Refer to this link: ALTER DATABASE (Transact-SQL) compatibility level