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

JonathanC

I am receiving this error when trying to connect to an Azure SQL Managed Instance using Azure Active Director - Password authentication. I have checked "Trust Server Certificate" in options. Please help.

SQL Source Control can't access this database. Make sure the database is online, you have permission to access it and you are using a supported authentication type.

Kurt_M

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.

JonathanC

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

Kurt_M

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.

JonathanC

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

Kurt_M

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 

JonathanC

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

Kurt_M

Hi @JonathanC

Yes definitely, I'll let you know once this issue has been fixed.

DanC

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

JonathanC

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

DanC

Hi @JonathanC

What type of database are you trying to link?

JonathanC

Azure SQL Managed Instance. See above for details.

DanC

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

JonathanC

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.

DanC

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