Forum Discussion

sksingh123's avatar
sksingh123
Copper Contributor
Mar 11, 2025

Creating LinkedServer between On-Prem SQL to Azure SQL MI

Hi,

is it possible to use security option (Be made using the login's current security context )with lnikedserver from on-prem SQL to MI ?

Our MI is enabled for windows auth and we are successfully connect MI in SSMS using windows auth from on-prem client.

when I use this option in linkedserver and try to access linked server with windows auth I get following error.

Login failed for user '<token-identified principal>'. Reason: Could not find a user matching the name provided

1 Reply

  • Shivmdba's avatar
    Shivmdba
    Copper Contributor

    It seems the AD users is not available in MI. please check 

Resources