declare @usr nvarchar(63)=N'MyLoginSQL',@pss nvarchar(128)=N'MySecretPass',@cat nvarchar(64)=N'AW17'
---- OLEDB/NCLI
EXEC master.dbo.sp_addlinkedserver @server = N'tcp:192.168.72.131,1433', @srvproduct=N'SQL Server'
EXEC master.dbo.sp_addlinkedserver @server = N'R-NCLI', @srvproduct=N'', @provider=N'SQLNCLI11', @datasrc=N'tcp:192.168.72.131,1433', @provstr=N'Provider=SQLNCLI11.1;Persist Security Info=False;Data Source=tcp:192.168.72.131,1433;Language=English;Connect Timeout=3;Workstation ID=MyTestPC;Application Intent=ReadOnly;Initial Catalog=AW17;Packet Size=8192', @catalog=@cat
EXEC master.dbo.sp_addlinkedserver @server = N'R-DRV', @srvproduct=N'', @provider=N'MSOLEDBSQL', @datasrc=N'tcp:192.168.72.131,1433', @provstr=N'Provider=MSOLEDBSQL.1;Persist Security Info=True;Data Source=tcp:192.168.72.131,1433;Language=English;Connect Timeout=3;Workstation ID=MyTestPC;Application Intent=ReadOnly;Initial Catalog=AW17;Packet Size=8192', @catalog=@cat
EXEC master.dbo.sp_addlinkedserver @server = N'R-MIX', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'tcp:192.168.72.131,1433', @provstr=N'Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=tcp:192.168.72.131,1433;Language=English;Connect Timeout=3;Workstation ID=MyTestPC;Application Intent=ReadOnly;Initial Catalog=AW17;Packet Size=8192', @catalog=@cat
EXEC master.dbo.sp_addlinkedserver @server = N'R-PROV', @srvproduct=N'', @provider=N'SQLOLEDB', @datasrc=N'tcp:192.168.72.131,1433', @provstr=N'Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=tcp:192.168.72.131,1433;Language=English;Connect Timeout=3;Workstation ID=MyTestPC;Application Intent=ReadOnly;Initial Catalog=AW17;Packet Size=8192', @catalog=@cat

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'tcp:192.168.72.131,1433',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'R-NCLI',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'R-DRV',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'R-MIX',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'R-PROV',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss

---- ODBC (only x64, no x86/x32)
EXEC master.dbo.sp_addlinkedserver @server = N'ODBC64-17', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'odbc64-17', @catalog=@cat
EXEC master.dbo.sp_addlinkedserver @server = N'ODBC64-SQL', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'odbc64-sql', @catalog=@cat
EXEC master.dbo.sp_addlinkedserver @server = N'ODBC64-NCLI', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'odbc64-ncli', @catalog=@cat
EXEC master.dbo.sp_addlinkedserver @server = N'ODBC64-NCLI-RDA', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'odbc64-ncli-rda', @catalog=@cat

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ODBC64-17',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ODBC64-SQL',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ODBC64-NCLI',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ODBC64-NCLI-RDA',@useself=N'False',@locallogin=NULL,@rmtuser=@usr,@rmtpassword=@pss