Skip to main content
Solved

Azure SQL managed identity authentication


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

 

Best answer by Thomas Lind

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.

View original
Did this topic help you find an answer to your question?

2 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1029 replies
  • Answer
  • April 16, 2024

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.


  • Author
  • Starter
  • 1 reply
  • April 16, 2024

Thanks @Thomas Lind , will add to ideas list


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings