selectstarfromyogi

sql server DBA ,sql server 2008 , 2012 , 2014 ,sql

Menu
Search
Skip to content
  • Home
  • About

remote login mapping in linked server

how to map local server login to remote server login in linked servers – SQL Server

syntax: EXEC sp_addlinkedsrvlogin ‘linked servername’, ‘false’, ‘local login’, ‘remote login name’, ‘remote login password’

EXEC sp_addlinkedsrvlogin ‘LNK_PROD’, ‘false’, ‘domain\abc’, ‘user1’, ‘Password!’

September 13, 2015yogigollapudi linked server, remote login mapping in linked server Leave a comment

Categories

  • DEVOps (1)
  • Errors (9)
  • FUN (1)
  • Performance Tuning (11)
  • powershell (12)
  • T-SQL (43)
  • Uncategorized (154)

Blog Stats

  • 39,568 hits
Follow selectstarfromyogi on WordPress.com
Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • selectstarfromyogi
    • Already have a WordPress.com account? Log in now.
    • selectstarfromyogi
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Design a site like this with WordPress.com
Get started