This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
I have a requirement wherein I need to copy data from AAS via ADF and I am following the below blog :
https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/
But we have a scenario wherein we have MFA configured in our accounts. So how should we create a linked server?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 63%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hello @Sahil Mehta ,
Thanks for the question and using MS Q&A platform.
If my understanding is correct you'd like to know how to create a linked server using a SQL instance? Can you please let me know what version are you makin use of ?
Yes,
I am trying to create a lined server on SQL 2012 and SQL 2016 to Azure analyis service and the login account has MFA set up because of which unable to do it.
So how to proceed in such scenario
Hello @Sahil Mehta ,
Thanks for getting back.
I came across a similar discussion in the below thread - The Answer by Pradeep talks about handling the MFA. Just wanted to understand whether you have already tried the below :
@svijay-MSFT / @PRADEEPCHEEKATLA-MSFT
When I tried creating linked server via
https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/
I am getting the below error :
and when I am trying this link :
https://learn.microsoft.com/en-us/answers/questions/276132/creating-linked-server-to-connect-to-azure-analysi.html
I am getting the below error :
So is it even possible?
Hello @Sahil Mehta ,
Thank you for getting back.
I had been researching further. This would need deeper investigation. I'd recommend you open a support ticket with Microsoft Support Team to have closer look.
Please do let us know if you have any further questions.
Were you able to create a linked server on SQL server to AAS with MFA enabled?
And whether this issue is specific to my systems ? Or it is not even possible to have it
Hello @Sahil Mehta ,
I did not get a chance to set it up at my end.
however, per my research, your requirement appears to be possible.
Hey Sahil,
Good day!
MSFT confirmed that the above approach with MFA in an automated way is not possible.