EXEC sp_addlinkedserver
@server=N'linked', -- Linked Server Display Name
@srvproduct=N'', -- Default to SQL Server
@provider=N'SQLNCLI', -- Use SQLNCLI
@datasrc=N'tcp:172.xx.xx.xx'; -- VPC IP of remote server, force TCP mode

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'linked' -- Linked Server Display Name
, @useself = 'false' -- Do not masquerade
-- , @locallogin = '' -- Commented out to force all local users to use linked login
, @rmtuser = 'remoteuser' -- Remote user name
, @rmtpassword = 'remotepass'; -- Remote password