Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control: Azure

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Support Azure Active Directory Authentication

This has over 50 votes but its in SQL Prompt. This is a HUGE pain for us as we need to use AD to adhere to security policy.
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/15008409-add-support-for-azure-active-directory-authenticat

285 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
under review  ·  Kendra responded  · 

Thanks to everyone for submitting feedback on this in the form of both voting and comments.

Currently, SQL Source Control does not have strong support for Azure SQL Database: as folks have noted in this item, AAD support, particularly with multi-factor authentication, is desired. Currently SQL Source Control does not work at all with Azure SQL Database with MFA enabled.

An additional issue worth mentioning is that pains with SQL Source Control performance may be worse than interacting with Azure SQL Database due to latency.

We would like to improve the user experience and support for Azure SQL Database, and doing so almost certainly involves addressing both of these issues. This is an area we are beginning to investigate more fully.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    So this request was first raised in 2016!!!!
    Nearly 6 years on and still no resolution.

    Redgate is becoming a company that is out of touch with its userbase and is quite happy to carry on collecting the money for Source Control but not add any new features that its developers actually want.

    There are alternatives to look at now and I shall be advising my company to look at them.

  • onur commented  ·   ·  Report

    This is a big roadblock for our development team. Looking forward to AAD & MFA support. Until then, we won't be able to use your product.

  • Joe commented  ·   ·  Report

    This prevents our entire development team from using the product since we're all using Azure AD. Only the DBAs are able to use it since they're the only ones with SQL logins.

  • Benjamin Abbott commented  ·   ·  Report

    I would like to link a local database in SQL Source Control to our Azure DevOps repository. However, as my Azure login has MFA enabled, I am unable to do so. This is a huge pain and I do not want to use GIT as this is a poor workaround to something that should just work (how long has MFA been around?!).

    Please add proper support for Azure DevOps to SQL Source Control, including full support for MFA.

  • Keith Voels commented  ·   ·  Report

    This is a showstopper. Funny that the demos center around Microsoft Azure yet the ONLY way to properly do authentication is not supported.

  • Anonymous commented  ·   ·  Report

    Any update or roadmap plans Red-Gate can share regarding AAD & MFA authentication support?

  • Brad commented  ·   ·  Report

    Just agreeing with all of the previous posters who are saying this is a necessity for using Redgate Source Control. Any word on progress?

  • Anonymous commented  ·   ·  Report

    Why is this not possible after all of this time?

    We have almost completed a company-wide migration to Azure SQL databases, and now we can't use the tools we are used to using.

    SQL Source Control needs to support Active Directory authentication - with MFA support too.

  • Nick Orlando commented  ·   ·  Report

    This is an absolute necessity for us to continue using RedGate. If not added, we will be forced to consider alternatives for Source Control in SQL.

  • Patrick Steele commented  ·   ·  Report

    Agree with Dan. We have heavy security and compliance processes coming up that will necessitate some databases having AAD access only. If SQL Source Control can't support that, we'll have to look elsewhere.

  • Dan Tape commented  ·   ·  Report

    This is unbelievable that something so fundamental to everything in azure redgate doesn't support yet. This adds a whole new layer of security and compliance for us if we want to use and expand the use of your tools in our environment since everyone needs to now have SQL auth accounts just to use prompt and source control.

  • Tony Paten commented  ·   ·  Report

    This is a must have to integrate Redgate in the cloud while using a much preferred authentication mechanism.

  • Travis Kale commented  ·   ·  Report

    Would be great to have, consider this vote a vote for AAD support in ALL toolbelt products.