EXEC sp_addlinkedserver @server=N'wradminlite', -- Linked Server Display Name @srvproduct=N'SQL Server', -- Default to SQL Server @provider=N'SQLNCLI', -- Use SQLNCLI @datasrc=N''; -- VPC IP of remote server, force TCP mode EXEC sp_addlinkedsrvlogin @rmtsrvname = 'wradminlite' -- Linked Server Display Name , @useself = 'false' -- Do not masquerade -- , @locallogin = '' -- Commented out to force all local users to use linked login , @rmtuser = '' -- Remote user name , @rmtpassword = ''; -- Remote password