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(25.6, 39%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Hello All,
I am using Azure SQl MI. I need to connect to an active directory and get some details. to do this matter I am using link server and Open query.
when I am running my query, I get the following error:
"The OLE DB provider "ADSDSOObject" has not been registered."
When I checked the Link server Provider, I noticed "AllowInProcess" for "ADSDSOObject" is not enabled.
Then I execute this code successfully : EXEC master.dbo.sp_MSset_oledb_prop N'ADsDSOObject', N'AllowInProcess', 1
However, it's not working and the value of the "AllowInProcess" for "ADSDSOObject" will turn to 0 again.
I do not know why this is happening.
Any help is appreciated.
![](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(134.4, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
Can you let me know if you were able to get alternative solution to connect ADSDSObject from Azure MI?
Hi, maybe can you to resolve the problem with connect ADSDSObject from Azure SQL Managed Instance?
I believe that the only linked servers you have in Azure MI are other Azure MI. I would not expect Active Directory to be supported.