Sql management Studio cosmos linkedServer-CodePudding

I trying to create a linkedServer over sql management studio and a cosmos db.

I already created the system data source and the test is fine:

But after create the linkedServer when i trying to open this error appears :

I'm creating the linke server with the following command :

USE [master]
GO

EXEC master.dbo.sp_addlinkedserver @server = N'DEMOCOSMOS', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'CosmosDev'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DEMOCOSMOS', @useself=N'False', @locallogin=NULL, @rmtuser=NULL, @rmtpassword=NULL

GO

CodePudding user response：

unchecked the "Allow inprocess" option in the MSDASQL provider and reboot the server completely

Sets server options for remote servers and linked servers by sp_serveroption.

To create and Query Azure CosmosDB from a SQL Server Linked Server you can refer this document.