The OLE DB provider "ADSDSOObject" has not been registered - in Azure SQL Managed Instance

user_7137216 0
Viewed 175

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.

Image - ADSDSOObject settings on Azure SQL MI

Then I execute this code successfully:

EXEC master.dbo.sp_MSset_oledb_prop N'ADsDSOObject', N'AllowInProcess', 1

However, it is not working and the value of the "AllowInProcess" for "ADSDSOObject" will turn to 0 again.

Image - I cannot configure ADSDSOObject on Azure SQL MI

I do not know why this is happening.

Does Azure SQL MI support ADSDSOObject?

If ADSDSOObject is supported in Azure SQL Managed Instance, how to configure "ADSDSOObject"?

Any help is appreciated.

oledb azure sql-server sql
1 Answers

There are only a limited number of linked server targets that are supported in Azure SQL Managed Instance like SQL Managed Instance, SQL Database, etc.

You can check this MS document for Linked servers targets list and operations supported in Azure SQL Managed Instance.

Currently, Azure SQL Managed Instance does not Support Active directory yet.

user_159691070
Related