SQL Source control can't access this database
Saloni
Posts: 3 New member
Make sure the database is online, you have permission to access it and you are using a supported authentication type.
Can I get a bit more insight on this error message?
Can I get a bit more insight on this error message?
Tagged:
Answers
What authentication method are you using to connect to the server? Are you potentially trying to connect to an Azure instance with Azure Active Directory Interactive Authentication (MFA)?
Has this worked previously and since stopped working, or a new setup?
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
This is a new setup that I am trying to connect to.
I have 3 different RDS SQL Server environments Dev, Stage, and Prod. I'm getting this error on Prod, but not on Dev.
Any recommendations?
I reached out to Redgate support. They said the current version has a bug and provided me with the previous version that resolved my issue. I would recommend the same.
Good luck!
We don't have an update at this stage. I'd recommend downgrading to the following version for now:
https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.3.36.16024.exe
I'd also recommend keeping an eye on the release notes page for further updates:
https://documentation.red-gate.com/soc/release-notes-and-other-versions/sql-source-control-7-4-release-notes
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
Apologies, but this issue is still being worked on. We don't have a release just yet. Once there is an update, I'll make sure to post on this thread letting everyone know.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
Apologies for the delay. You'll need to try uninstall SQL Source Control first from the control panel before you can install the previous version.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
regards,
James
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
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
I would recommend fully uninstalling SQL Source Control and then re-installing the 7.5.4.16994 release:
https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
If you are receiving the same error message as the others, but are using a version after 7.5.4 containing the fix, then this might be a different issue you're coming across. In order to diagnose further, I would need to see your SQL Source Control log files, which authentication method you are using and if it's related to a local database or Azure. Also, the process you go through to replicate the error would be helpful.
I would also be interested to know which version of SSMS you are using.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
Thanks Bodders
Unfortunately, SQL Source Control doesn't support MFA authentication, so this is likely why you are coming across your error. Here is the relevant documentation page for that:
https://documentation.red-gate.com/soc/requirements-and-supported-systems#:~:text=source%20control.-,Supported%20authentication%20methods,-Windows%20Integrated%20Authentication
If you require MFA, I would suggest looking into our Flyway product.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center