SQL Source Control can't access this database - Azure SQL Managed Instance

• 
  Hi JonathanC,
  
  Can I ask what version of SQL Source Control you're using when you get this error?
  
  I've seen this issue from other customers before and it's usually related to a permissions issue. In a local SQL Server environment we would give "sysadmin". In the case of Azure, the equivalent role is "dbmanager" or "loginmanager", which you will need to give to the user you're using, which should hopefully resolve the issue.
  

  Kurt_M December 05, 2022 05:53

  - 0 +
• 
  I don't see either of those roles in SQL Server. This is a Azure Managed Instance, not Azure SQL. Are those Azure SQL roles? I already have sysadmin role.
  
  SQL Server Management Studio 15.0.18424.0

  SQL Source Control 7.4.6.16349
  

  JonathanC December 05, 2022 16:20

  - 0 +
• 
  Hi @JonathanC,
  
  Apologies for the delay.
  
  For the time being, can you please downgrade to the following version:
  
  https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.4.6.16349.exe
  
  This is currently a known issue that is being looked into. Downgrading should restore functionality.

  Kurt_M December 12, 2022 06:08

  - 0 +
• 
  What version should I downgrade to? That's the same version I'm currently using.

  JonathanC December 12, 2022 13:35

  - 0 +
• 
  Hi @JonathanC
  
  Apologies, I had copied the wrong link. Please use the below version:
  
  https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.3.36.16024.exe

  Kurt_M December 12, 2022 13:43

  - 0 +
• 
  That version is working for me! Can you please let me know when it's fixed in the latest version? Thank you!

  JonathanC December 12, 2022 14:01

  - 0 +
• 
  Hi @JonathanC
  
  Yes definitely, I'll let you know once this issue has been fixed.

  Kurt_M December 13, 2022 08:01

  - 0 +
• 
  Hi @JonathanC
  
  Thank you for your patience on this issue!
  

  We now have a release which contains the latest SQL Compare engine and this should resolve the issue you was experiencing!

  Are you able to patch into v7.5.4 at your earliest convenience and confirm if this issue has been resolved.

  Download link available here: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe

  Patch note 7.5.4.16994 - February 28th, 2023

  Improvements

  • VT-282 - Providing support for SSMS 2019 GA.
  • Updated SQL Compare Engine to 15.0.5.23167

  DanC March 01, 2023 09:55

  - 0 +
• 
  That version seems to be connecting to Azure, but the Setup screen doesn't allow me to set up a database for source control.

  JonathanC March 08, 2023 16:51

  - 0 +
• 
  Hi @JonathanC
  
  What type of database are you trying to link?

  DanC March 08, 2023 16:58

  - 0 +
• 
  Azure SQL Managed Instance. See above for details.

  JonathanC March 08, 2023 17:01

  - 0 +
• 
  Hi @JonathanC
  
  Unfortunately, you can't use Azure SQL Managed Instances with SQL Source Control as it's not supported by the tool. In order to source control an Azure SQL MI you will need to use Flyway Desktop: https://documentation.red-gate.com/soc/requirements-and-supported-systems
  
  
  

  DanC March 08, 2023 17:31

  - 0 +
• 
  It works in version 7.3.36 and below. I thought the above message was informing me it was finally fixed in version 7.5.4.

  JonathanC March 08, 2023 17:59

  - 0 +
• 
  Hi @JonathanC
  
  Unfortunately, if you managed to link to an Azure SQL Managed Instance then it was pure luck as we don't support it in SQL Source Control
  
  The latest update was to fix the Microsoft.Data.SqlClient in the tool

  DanC March 10, 2023 09:43

  - 0 +

Add comment

Please sign in to leave a comment.