Advertisement
Guest User

Untitled

a guest
Apr 3rd, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. EXEC sp_addlinkedserver
  2. @server=N'wradminlite', -- Linked Server Display Name
  3. @srvproduct=N'SQL Server', -- Default to SQL Server
  4. @provider=N'SQLNCLI', -- Use SQLNCLI
  5. @datasrc=N''; -- VPC IP of remote server, force TCP mode
  6.  
  7. EXEC sp_addlinkedsrvlogin @rmtsrvname = 'wradminlite' -- Linked Server Display Name
  8. , @useself = 'false' -- Do not masquerade
  9. -- , @locallogin = '' -- Commented out to force all local users to use linked login
  10. , @rmtuser = '' -- Remote user name
  11. , @rmtpassword = ''; -- Remote password
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement