Changing Linked Server Properties

• David Fundakowski

  Ten Centuries

  Points: 1328

  More actions

  July 7, 2016 at 12:15 am

  #319735

  Comments posted to this topic are about the item Changing Linked Server Properties

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  July 7, 2016 at 6:25 am

  #1888891

  Thanks for the education about linked servers. We have created some backup servers that we want to link.

• chudman

  SSCrazy

  Points: 2453

  More actions

  July 7, 2016 at 7:25 am

  #1888908

  Thanks for the write-up. Most of the problems people have with linked servers are a result of permissions and remote logins. This article seems to deal with an environment wherein the DBA has privileges on both linking server and server to be linked to, so it seems to be limited linking SQL servers only or for very small shops.

  For other data sources like Oracle, Sybase, Teradata, and others, the security tab should get some focus, as that is the tricky part of the linked server set-up.

  Thanks

  Jeff Bennett

  St. Louis, MO