How can we help you today? How can we help you today?

Code Analysis doesn't load with SSMS 19.0.1

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!
SnortyNorty
0

Comments

2 comments

Sort by

Add comment

Please sign in to leave a comment.