cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot login to databricks using SSO

nagendrapruthvi
New Contributor

 

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?



2 REPLIES 2

NandiniN
Databricks Employee
Databricks Employee

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. 

NandiniN
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group