How I can create Linked Server on Linux SQLServer 2017

It is possible to create linked server from SQLServer 2017 on Linux, to Oracle database,

which steps are needed?


Linked server to Oracle is not supported

Unsupported features & services

  • Linked Servers to data sources other than SQL Server

see unsupported features.

if you want to create linked server to a SQL server, then below T-sql will work (I have tested it and it works fine)

EXEC master.dbo.sp_addlinkedserver
     @server = N'serverB', -- destination server Name 
     @srvproduct = N'',
     @provider = N'SQLNCLI',
     @datasrc = N'xx.xx.xx.xx', -- IP address of the destination server 
     @catalog = N'master'; -- db Name 
GO
EXEC master.dbo.sp_addlinkedsrvlogin
     @rmtsrvname = N'serverB',-- destination server Name 
     @useself = N'False',
     @locallogin = NULL,
     @rmtuser = N'sa', -- remote login name 
     @rmtpassword = '#######'; -- remote login password 
GO