Unable to view azure active directory logins in SQL managed instance on azure

• brijesh_c

  SSC Rookie

  Points: 34

  September 25, 2019 at 5:48 am

  #3683193

  Hi,

  I have created azure active directory logins in my SQL managed instance on azure. I can see them if I execute

  SELECT * FROM SYS.SERVER_PRINCIPALS. But if I go to instance>>security>>Server Roles>> these azure active directory logins are not visible there. I'm sysadmin for this instance. Any clue?

  Thanks

   

• Site Owners

  SSC Guru

  Points: 80380

  September 26, 2019 at 6:10 am

  #3683512

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Andrey

  SSChasing Mays

  Points: 650

  September 26, 2019 at 8:36 am

  #3683534

  Are they visible in "Instance->Security->Logins" ?

• Spindrift

  Ten Centuries

  Points: 1087

  September 30, 2019 at 11:48 am

  #3684513

  Hi,

  *Edit*

  I resolved this by installing latest GA of SSMS locally - have you tried that?

  • This reply was modified 1 month, 2 weeks ago by  Spindrift.