Source control 5.7.6.6321 is allowing me to connect to my azure databases with sql auth, but not ad?

• 
  Hey @shollingshead,
  I guess this is not really related to the product. If you try to connect to Azure SQL Database using SQL Server Management Studio, are you able to connect via integrated security, since you're out of the domain with your local/roaming credential?

  AlessandroAlpi August 25, 2017 21:18

  - 0 +
• 
  Seeing the same thing with SQL Source Control 5.6.1.5788. When connected to my Azure SQL DB that is secured via Azure Active Directory, I can't link it to source control. When I try, it simply says:
  
  SQL Source Control can't access this database. Make sure the database is online and you have permissions to access it.
  
  Looking at the SQL Source Control logs, the only error I see is:
  
  13:29:59.254|WARN |AllDatabasesProvider|22 |Error getting databases
  System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
  
  SQL Search also doesn't support AzureAD-secured Azure SQL DB's so I assume this is the same/similar problem.

  PatrickS August 31, 2017 17:35

  - 0 +
• 
  Hi PatrickS. You are on to something there for sure. That is my exact issue as well. So my question to any red-gate people is: Is there a plan for SQL source control to support specifying logon servers so we can link to it with sql source control? If i could only specify the logon server, everything would work fine.

  shollingshead August 31, 2017 20:15

  - 0 +
• 
  Same issue here on version 6.1.8.7584. I have raised a support ticket.

  JordanD June 14, 2018 22:51

  - 0 +
• 
  I am on 6.1.8.7584 as well and having the same issue. Is there a way to get past it using AD auth? I don't really want to connect using the azure sql auth admin account just to use source control.

  Dan_T July 11, 2018 15:41

  - 0 +
• 
  Hi all,
  
  SQL Source Control currently does not support Azure AD authentication, I'm very sorry to say.
  
  If you are looking for this feature, can you please vote on the request here if you haven't already: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/16531591-support-azure-active-directory-authentication

  Jessica R July 18, 2018 22:17

  - 0 +
• 
  How is this still not possible?

  
  

  The UserVoice request is from 2016, and has more votes that similar request for other products, which have already implemented this. Azure AD authentication isn't new and neither is Azure SQL Database.
  

  doyle_am September 04, 2018 07:57

  - 0 +
• 
  why is this still not fixed

  ozhug March 13, 2020 01:09

  - 0 +

Add comment

Please sign in to leave a comment.