Disabling SQL Authentication after switching to Azure AD
S
Syedhasan
started a topic
almost 2 years ago
Can SQL Authentication for an Azure Database Server be disabled once identity management is configured to use Azure AD authentication and appropriate users and and roles are set up to use Azure AD as the identity provider?
In other words, is the default built-in authentication where a SQL Admin Account and Password are required, this is only for the initial setup of Semarchy?
Best Answer
S
Stéphanie FOURRIER
said
over 1 year ago
Hi Rohan, you might want to open a support ticket to get linked to the existing enhancement request MDM-12667 and receive notifications once it is resolved and released in a new xDM version (this is not planned yet).
you can disable the internal authentication, this is not required.
Authenticate as an admin using another Identity management
Go the Configuration -> Identity Management, turn off Internal - Built-in and click on the save button
I hope this helps.
Best regards,
Stéphanie.
R
Rohan Cragg (Quorum)
said
almost 2 years ago
The answer from Stephanie Fourrier does not actually answer the question being asked. The question relates to how Semarchy xDM authenticates itself to the backed Repository database server / database. The answer given relates to end-user authentication to the Semarchy xDM application.
S
Stéphanie FOURRIER
said
almost 2 years ago
Hi Rohan, sorry this was not clear to me.
The connectivity to the repository is not used only when you initialize xDM. This is needed all the time being of your work with the tool as it stores all you model information as well as the batch processing tasks and detailed logging informations.
The connectivity to the repository cannot be disabled.
I don't see this documented anywhere and so it is likely a new feature request for Semarchy xDM. Is there somewhere we can make a new feature request?
For this to work according to the documentation I have included in the link above, xDM would have to use clientID and clientSecret to obtain JWT token which it then uses in the SQL DB connection.
Hi Rohan, you might want to open a support ticket to get linked to the existing enhancement request MDM-12667 and receive notifications once it is resolved and released in a new xDM version (this is not planned yet).
Syedhasan
Can SQL Authentication for an Azure Database Server be disabled once identity management is configured to use Azure AD authentication and appropriate users and and roles are set up to use Azure AD as the identity provider?
In other words, is the default built-in authentication where a SQL Admin Account and Password are required, this is only for the initial setup of Semarchy?
Hi Rohan, you might want to open a support ticket to get linked to the existing enhancement request MDM-12667 and receive notifications once it is resolved and released in a new xDM version (this is not planned yet).
Best regards,
Stéphanie.
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstStéphanie FOURRIER
Hi Syedhasan,
you can disable the internal authentication, this is not required.
I hope this helps.
Best regards,
Stéphanie.
Rohan Cragg (Quorum)
The answer from Stephanie Fourrier does not actually answer the question being asked. The question relates to how Semarchy xDM authenticates itself to the backed Repository database server / database. The answer given relates to end-user authentication to the Semarchy xDM application.
Stéphanie FOURRIER
Hi Rohan, sorry this was not clear to me.
The connectivity to the repository is not used only when you initialize xDM. This is needed all the time being of your work with the tool as it stores all you model information as well as the batch processing tasks and detailed logging informations.
The connectivity to the repository cannot be disabled.
Does it answer better your question ?
Best regards,
Stéphanie.
Rohan Cragg (Quorum)
Thank you for the reply Stéphanie.
No, this doesn't answer the question either.
What we want to do is to only use Azure AD authentication with Azure SQL
This would mean that xDM is not permitted to use a username and password to connect to the Repository DB but it would need to use an Azure AD token to connect as an Azure AD Application Principal.
I don't see this documented anywhere and so it is likely a new feature request for Semarchy xDM. Is there somewhere we can make a new feature request?
For this to work according to the documentation I have included in the link above, xDM would have to use clientID and clientSecret to obtain JWT token which it then uses in the SQL DB connection.
This link would also be useful Create Azure AD users using service principals - Azure SQL Database
Many Thanks, Rohan.
Stéphanie FOURRIER
Hi Rohan, you might want to open a support ticket to get linked to the existing enhancement request MDM-12667 and receive notifications once it is resolved and released in a new xDM version (this is not planned yet).
Best regards,
Stéphanie.
-
Deployment History Date
-
Username in Tomcat Access Logs
-
Is It Possible to Perform Automatic Authentication with The User's Windows Account?
-
Where is the documentation for Version 5.2.5?
-
On Prem Semarchy Authentication using Azure AD?
-
Delete old models
-
Sync production model version with dev
-
Recreate a dev environment. Any side effect?
-
Indexes on xDM database tables
-
What logging technology is used in the Semarchy xDM platform?
See all 60 topics