Code Analysis doesn't load with SSMS 19.0.1
SnortyNorty
Posts: 1 New member
in SQL Prompt
Hi Everybody:
Using SSMS 19.0.1 with an Azure SQL or Azure Managed Instance and SQLPrompt 10.13.5.16 causes me to be prompted for a Microsoft login. No errors are displayed, but the Code Analysis doesn't load. I looked in the SQLPrompt logs and found that the Microsoft login is failing:
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
System.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'. The server is not currently configured to accept this token.
Anyone know of a way to configure SQLPrompt around this for Azure servers, or is it just not compatible with SSMS 19 yet?
FYI: SSMS19 works with on-prem servers and VMs, so the issue seems to be with authenticating through an Azure Active Directory.
Cheers and Thanks!
Using SSMS 19.0.1 with an Azure SQL or Azure Managed Instance and SQLPrompt 10.13.5.16 causes me to be prompted for a Microsoft login. No errors are displayed, but the Code Analysis doesn't load. I looked in the SQLPrompt logs and found that the Microsoft login is failing:
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
System.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'. The server is not currently configured to accept this token.
Anyone know of a way to configure SQLPrompt around this for Azure servers, or is it just not compatible with SSMS 19 yet?
FYI: SSMS19 works with on-prem servers and VMs, so the issue seems to be with authenticating through an Azure Active Directory.
Cheers and Thanks!
Tagged:
Answers
I am raising this with the development team currently.
Hi There,
This should be fixed in 10.13.13
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.13.2147.exe
Would you be able to install this and let me know if this fixes it for you?