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

• brijesh_c

  Valued Member

  Points: 64

  More actions

  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: 80320

  More actions

  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

  Right there with Babe

  Points: 780

  More actions

  September 26, 2019 at 8:36 am

  #3683534

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

• Spindrift

  Ten Centuries

  Points: 1227

  More actions

  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 4 years, 6 months ago by  Spindrift.