How to Re-enable Basic Authentication After It Was Disabled by Azure SSO Integration

News Knowledge Base
,
1

How to Re-enable Basic Authentication After It Was Disabled by Azure SSO Integration

Issue Description

When configuring Azure SSO, basic authentication may be disabled in UiPath Orchestrator, potentially locking out users.

Resolution

To restore access, modify the authentication setting "Auth.RestrictBasicAuthentication" in the UiPath database.

Prerequisites

  • Access to the SQL Server hosting the UiPath database.
  • Permission to execute SQL queries on the [UiPath].[identity].[Settings] table.

Steps

Note: first, back up the database before making any changes.

  1. Connect to the SQL Server using the appropriate credentials
  2. Execute the following SQL query:
SELECT * FROM [UiPath].[identity].[Settings] WHERE [Key] = 'Auth.RestrictBasicAuthentication';

(This query retrieves the current value of the key "Auth.RestrictBasicAuthentication" from the Settings table).

  1. Verify the Query Result:

If the query returns a row with the key 'Auth.RestrictBasicAuthentication' and its value is set to true, proceed to the next step.

  1. Update the Setting: Execute the following SQL statement to change the value of "Auth.RestrictBasicAuthentication" to false:
UPDATE [UiPath].[identity].[Settings]

SET [Value] = ‘false’


WHERE [Key] = ‘Auth.RestrictBasicAuthentication’;

  1. This SQL statement updates the value of the key "Auth.RestrictBasicAuthentication" to false in the Settings table.

image2.JPG

Outcome

After this change, basic authentication should be restored, allowing login access using basic credentials.