Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement