SQL Source Control Support for Azure SQL database

• 
  To validate this works, I just connected an Azure SQL Database to my Team Foundation Services source control. Everything ought to work.
  
  Make sure you have the latest version. I think some of the older versions had a problem with Azure.

  Grant November 06, 2017 15:17

  - 0 +
• 
  I am running SQL Source Control 6.1.8. I'm trying to link an Azure database to my TFS but I'm getting an error: SQL Source Control can't access this database. Make sure the database is online and you have permission to access it.
  
  I'm running SQL v17 with Redgate and I can connect to the server and database in question. I just cannot setup the link with source control.
  
  Any help would be greatly appreciated.

  Rob_Nguyen February 19, 2019 20:28

  - 0 +
• 
  That's exactly what happens to me!
  

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

  
  

  I'm running SSMS V17.9.1 with SQL Source Control 7.0.6.8775.
  

  
  

  Please give us some advice, which permissions are needed to set up source control on an Azure SQL Database..
  

  Thank you.

  Karsten63 February 28, 2019 11:29

  - 0 +
• 
  I'll just re-iterate that this isn't supported by SOC, but you may be able to get this working with a SQL user.
  

  Russell D March 01, 2019 09:20

  - 0 +
• 
  Is this still an outstanding issue with SQL Source Control? I am running into the same issues trying to get an Azure SQL Database into Source Control. I am on the current version (7.1.12). does this not support the AzureAD Integrated authentication? SQL Prompt has no issues working with it.

  Brijeet March 30, 2020 15:26

  - 0 +

Add comment

Please sign in to leave a comment.