Solved

Azure SQL managed identity authentication

  • 16 April 2024
  • 2 replies
  • 17 views

Hi all,

My first post here. My company is currently using legacy TX but I started poking around the new version. I was a bit surprised to find out that passwordless authentication methods are not supported yet. Are there plans to support managed identity authentication in the legacy or new version?

Our company security policy requires password expiration even on service accounts so you can imagine the hazard to update them in many places regularly.

TX MDW

 

SSMS

 

icon

Best answer by Thomas Lind 16 April 2024, 16:16

View original

2 replies

Userlevel 6
Badge +5

Hi @azolotoiy 

For some areas you can use an app to gain access.

You can use it for PowerBI XMLA endpoint

https://support.timextender.com/semantic%2Dmodel%2D109/power%2Dbi%2Dpremium%2Dendpoint%2D715#(Optional)+Authenticate+using+a+Service+Principal%C2%A0

You can also use something similar to this in the Tabular endpoint.

https://support.timextender.com/semantic%2Dmodel%2D109/tabular%2Dendpoint%2D1041

Otherwise you are right, there is no option to add it to a SQL DB ODX or DW instance.

It is something that would be a good idea to add.

Thanks @Thomas Lind , will add to ideas list

Reply