topic Cannot login to databricks using SSO in Data Engineering

Cannot login to databricks using SSO

nagendrapruthvi — Tue, 15 Oct 2024 16:24:11 GMT

Hi, I created accounts with Databricks for both production and staging environments at my company, but I made a mistake with the case of the email addresses. For production, I used Xyz@company.com, and for staging, I used xyz@company.com.

Now that my organization has enabled Single Sign-On (SSO), I can no longer manually input my email and password. When I try to log in using SSO, I get the following error message:

"Automatic provisioning of user xyz to app Databricks failed: Error while verifying if user xyz@heb.com exists: Multiple users found by userName. Expected 0 or 1 results but was 2."

Could you please help with resolving this?

Re: Cannot login to databricks using SSO

NandiniN — Fri, 01 Nov 2024 05:55:59 GMT

Interesting, I had no idea on case sensitivity in emails, but it is possible. You need to delete one of the conflicting users(using admin/support help) from Databricks and recreate.

Re: Cannot login to databricks using SSO

NandiniN — Fri, 01 Nov 2024 06:01:47 GMT

Okay, so I checked some documents - The email addresses will also be case-insensitive, the same behavior as in AWS, Azure and GCP. This means that email addresses will be stored in lowercase in Databricks.

So, the issue is not with case sensitivity but same userName.

SCIM Errors

Full error message	*Occurs during setup or provisioning	Reason for error	Steps to resolve
`Multiple users found by userName. Expected 0 or 1 results but was 2`	Provisioning	The team members were stuck in a deactivated members collection in our database.	Contact Technical Support to have the deactivated members fully removed.