Network Management

Database Configuration Failed: Cannot delete user 'XXX'. Please delete the user manually and rerun the Configuration Wizard

This article describes how to resolve the Configuration Wizard message: "Database Configuration Failed: Cannot delete user 'XXX'. Please delete the user manually and rerun the Configuration Wizard.

First published date

11/29/2018 10:48 PM

Last published date

2/14/2025 9:25 PM

Overview

Configuration Wizard ends with the following error: 

Error Message:

"Database Configuration Failed: Cannot delete user 'XXX'. Please delete the user manually and rerun the Configuration Wizard.


Sample Image:

From Configuration Wizard logs:

Product section

Orion Platform

Cause

This message typically happens when the Orion database is migrated to a new SQL server and a new SQL account is needed.

2nd possible reason: 

The account was deleted or does not exist in "Security->Logins" from SQL Server Management Studio(SSMS).

Resolution

OPTION1:

  1. Login to Orion server with local admin account
  2. Open Configuration Wizard
  3. Select the option to create a new SQL account.

Note: If the SQL Environment is on a SQL Cluster, Try to switch or fail over to the other SQL node of the cluster. And make sure to use the listener.

 

OPTION2:

Check from Security->Logins in to SSMS and make sure the account used is listed.

If the account is missing, create the account used and grant with "security admin" privilege.