Comments
2 comments
-
Further to this I have attached a screenshot of the logs showing the failure.
Edit: Just tested this with SSMS 17.4 and all works fine using SQL Prompt 9.5 so appears that this does not work in SSMS 18. Are you able to confirm?
Thanks -
Hi @mediacomgds
We are aware of issues with Prompt and Azure. Since it's not officially supported, you may find it doesn't always work! Can you please add your vote to bellow posts?
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/38055124-mfa-multi-factor-support-for-azure-sql-databases
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/15008409-add-support-for-azure-active-directory-authenticat
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1413159-support-sql-azure
Add comment
Please sign in to leave a comment.
We upgraded our version of SSMS and SQL Prompt but it has stopped working when connecting to an Azure SQL DB. We connect to Azure SQL using Azure Active Directory - Universal with MFA and looking at the logs it appears SQL Prompt is unable to log into the server because it is forming the"server" name wrong.
Please can somebody help?
Thanks