Can Source Control be used with an Azure managed database and interactive MFA?
trg1984
Posts: 1 New member
We have an Azure managed database (not a managed instance) with Azure Active Directory Interactive Authentication (MFA). When I try to link the database to source control in SSMS, I get the following error:
"
SQL Source Control can't access this database.
Make sure the database is online, you have permission to access it and you are using a supported authentication type.
"
The database is online, and I have required permissions to access it. Based on this page, the authentication method is not supported:
https://documentation.red-gate.com/soc/requirements-and-supported-systems
Is there any way to use Redgate SQL Source Control with Azure managed databases and Azure AD Interactive Authentication (MFA), or is it only possible via products like Flyway Desktop as your page suggests?
"
SQL Source Control can't access this database.
Make sure the database is online, you have permission to access it and you are using a supported authentication type.
"
The database is online, and I have required permissions to access it. Based on this page, the authentication method is not supported:
https://documentation.red-gate.com/soc/requirements-and-supported-systems
Is there any way to use Redgate SQL Source Control with Azure managed databases and Azure AD Interactive Authentication (MFA), or is it only possible via products like Flyway Desktop as your page suggests?
Answers
SQL Source Control does support Azure SQL DBs. However it doesn't support Interactive / MFA auth. So instead you need to use SQL Server Auth.
This page on our documentation site confirms supported systems:
https://documentation.red-gate.com/soc/requirements-and-supported-systems
Victoria Wiseman | Redgate Software
Have you visited our Help Center?