Activity overview
Latest activity by David
UPDATE to my previous post. I generally have an SSMS solution open with a couple of project that contain a bunch of stored connections in the Connections folder. I deleted all of the connections that were hanging around in there and that cleared up the previous problem I was experiencing. Not sure how that was related but seemed to do the trick. If you are unable to upgrade SSMS/SQL Prompt, maybe give that a try. Currently: I've upgraded to SSMS 21.4.12 and SQL Prompt 11.0.7.17604. Red Gate has shifted to using a dedicated Entra Application ID. SQL Prompt and other Tools now use a Dedicated Entra ID Application for Azure SQL Databases – Update Required | Redgate When presented with the authorization dialog I had my Azure Admin remote to my computer and authorize the application with their account. Everything is working perfectly now. [image] / comments
UPDATE to my previous post. I generally have an SSMS solution open with a couple of project that contain a bunch of stored connections in the Connections folder. I deleted all of the connections ...
I am using SSMS 20.2.30 with SQL Prompt 10.16.12.16519. When connecting with Microsoft Entra with MFA I am able to use SQL Prompt but whenever I click into a query window I get an Entra login dialog box. I can ignore this box, leaving it open in the background, and everything works fine. Selecting an account in that box it fails with error: Message: AADSTS50011: The redirect URI 'urn:ietf:wg:oauth:2.0:oob' specified in the request does not match the redirect URIs configured for the application 'a94f9c62-97fe-4d19-b06d-472bed8d2bcf'. Make sure the redirect URI sent in the request matches one added to your application in the Azure portal. Navigate to https://aka.ms/redirectUriMismatchError to learn more about how to fix this. So, SQL Prompt is working fine as far as I can till it's just that the pop up is annoying. This just started to happen in the last couple of weeks or so. I believe it started when I was forced to switch to using the MFA option rather than just Entra username and password. Hope that helps. [EDIT] Forgot to mention that I confirmed it is SQL Prompt putting up the login by logging out of SQL Prompt in SSMS. The issue went away. The login returned after logging into SQL Prompt again in SSMS. / comments
I am using SSMS 20.2.30 with SQL Prompt 10.16.12.16519. When connecting with Microsoft Entra with MFA I am able to use SQL Prompt but whenever I click into a query window I get an Entra login dial...