Can't login to Azure SQL database

Can't login to Azure SQL database

avatar
cochrant

Currently one of our users is unable to login to RDM (Azure SQL Database). I tried to re-add the username but when I do I get this message below:


I tried doing what the messaged said and disabling user management for the user but no joy. Before this month the user was able to connect to this data source so I'm wondering what's going on?

image (14).png

All Comments (3)

avatar
Samuel Dery

Hello,

Thank you for reaching out to us regarding this,

Could you confirm which version of RDM you're currently using?

That being said, I'm wondering if you have access to your SA(DBO) user? If so, could you attempt to use it for this user creation?

Let me know if this works for you,

Best regards,

Samuel Dery

avatar
cochrant

I'm using version 2023.1.23.0 of RDM. I did try to add the user using my user which has administrator privileges, but I don't have access to the user account that created the Azure Sql database.

avatar
Samuel Dery

Hello,

Thank you for your reply,

I see, according to the error message, the error seems to be related to a permission issue with your user, this is why I wanted you to test using the DBO user, perhaps one of your colleagues has access to this?

Let me know,

Best regards,

Samuel Dery