Forum Discussion
sksingh123
Mar 11, 2025Copper Contributor
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
- ShivmdbaCopper Contributor
It seems the AD users is not available in MI. please check