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

Answers

• Options

  AlessandroAlpi Posts: 91 Gold 2

  August 25, 2017 9:18PM

  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?

  Alessandro Alpi
  CTO @ Engage IT Services s.r.l.
  Database Administrator and Team Leader
  Microsoft MVP - Data Platform
  Staff member of getlatestversion.it community
  personal website | blog

  0 · Share on Twitter
• Options

  PatrickS Posts: 3 New member

  August 31, 2017 5:35PM

  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.

  0 · Share on Twitter
• Options

  shollingshead Posts: 2 Bronze 2

  August 31, 2017 8:15PM

  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.

  0 · Share on Twitter
• Options

  JordanD Posts: 1 Bronze 1

  June 14, 2018 10:51PM

  Same issue here on version 6.1.8.7584. I have raised a support ticket.

  2 · Share on Twitter
• Options

  Dan_T Posts: 1 New member

  July 11, 2018 3:41PM

  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.

  0 · Share on Twitter
• Options

  Jessica R Posts: 1,319 Rose Gold 4

  July 18, 2018 10:17PM

  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 Ramos | Product Support Engineer | Redgate Software

  Have you visited our Help Center?

  
  

  0 · Share on Twitter
• Options

  doyle_am Posts: 2 Bronze 1

  September 4, 2018 7:57AM

  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.
  

  0 · Share on Twitter
• Options

  ozhug Posts: 5 Bronze 1

  March 13, 2020 1:09AM

  why is this still not fixed

  0 · Share on Twitter