Overview

If the Authentication Method in Umango is misconfigured (e.g., an incorrect LDAP or MFA setup), administrators may find themselves locked out of the system.

By removing the AuthenticationMethod entry from the database, Umango reverts to its default Windows/Domain Login state, allowing you to log back in and correct your settings.

Prerequisites

• Access to SQL Server Management Studio (SSMS).

• Connectivity to the Umango database instance (e.g., .\SQLUMANGO).

• Administrative permissions on the SQL instance.

Option 1: The Quick Fix (Recommended SQL Script)

This is the fastest and safest way to reset the setting without manually searching through table rows.

1. Open SQL Server Management Studio.

2. Click the New Query button in the top toolbar.

3. Copy and paste the following script into the query window:

/* Umango Authentication Reset Script
   Target: dbo.tbl_org_settings
*/

USE [Umango]; -- Ensure this matches your database name
GO

BEGIN TRANSACTION;

-- 1. Identify and delete the AuthenticationMethod row
DELETE FROM [dbo].[tbl_org_settings]
WHERE [name] = 'AuthenticationMethod';

-- 2. Verify the deletion
IF @@ROWCOUNT = 1
    BEGIN
        PRINT 'Success: AuthenticationMethod has been reset to default.';
        COMMIT TRANSACTION;
    END
ELSE
    BEGIN
        PRINT 'Notice: AuthenticationMethod row not found or already deleted.';
        ROLLBACK TRANSACTION;
    END
GO

4. Press F5 or click Execute.

5. Restart the Umango Service (via services.msc) to apply the changes.

Option 2: Manual Deletion (UI Method)

If you prefer to navigate the database manually:

1. In the Object Explorer, expand Databases > Umango > Tables.

2. Right-click dbo.tbl_org_settings and select Edit Top 200 Rows.

3. Locate the row where the name column is AuthenticationMethod.

4. Right-click the gray box at the far left of that row and select Delete.

5. Confirm the deletion and Restart the Umango Service.

After performing these steps, Umango will treat the next login attempt as a standard Windows/Domain authentication, exactly as it did during the initial installation.

Important Safety Note

Backup First: Before running any scripts or deleting rows, right-click your database and select Tasks > Back Up... to create a restore point.