Azure SQL Database - Active Directory Authentication Support

Austin_G

Does RedGate SQL Source Control Version 7.0.11.8919 support any of the following Azure Active Directory Authentication Schemes?

• Active Directory - Universal with MFA
• Active Directory - Password
• Active Directory - Integrated

When attempting to enable source control on a database using any of the authentication schemes above results in the following error message:

SQL Source Control can't access this database.
Make sure the database is online and you have permission to access it

When attempting to re-connect source control using Active Directory -XXX authentication scheme to a database that was previously linked using the SQL Authentication scheme results in the following error message

Login failed for user ''.

Currently there is an open User Voice feature request for Active Directory authentication from 2016 that is currently open.  It is unclear if this is a stale request that may have been implemented or is not a supported feature

https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/15008409-add-support-for-azure-active-directory-authenticat

Russell D

I'm afraid it does not, and we don't currently have any plans to add Support for it.

The feature request you've linked is for a different product, incidentally.