Can Source Control be used with an Azure managed database and interactive MFA?

trg1984

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?

Victoria W

Hi @trg1984

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 

bhargav1984

Any update on supporting MFA auth for Azure SQL DB?