Changing Linked Server Passwords

• thomasliddledba

  Ten Centuries

  Points: 1200

  More actions

  January 26, 2017 at 12:11 am

  #334423

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

  Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba

• vaa4

  SSC Journeyman

  Points: 80

  More actions

  January 26, 2017 at 7:12 am

  #1925051

  Tom,

  You may want to consider using pass-thorough  authentication.  This would make your enterprise more secure, as no passwords will be hard-coded into the linked server.
  It will, however, require Kerberos authentication to be configured, provided both servers exist in trusted domains.

• thomasliddledba

  Ten Centuries

  Points: 1200

  More actions

  January 26, 2017 at 7:58 am

  #1925064

  vaa4 - Thursday, January 26, 2017 7:12 AM

  Tom,

  You may want to consider using pass-thorough  authentication.  This would make your enterprise more secure, as no passwords will be hard-coded into the linked server.
  It will, however, require Kerberos authentication to be configured, provided both servers exist in trusted domains.

  That an option, however, in some organizations the linked server could be a SQL Server that is stand-alone in no domain, an Oracle Server or MySQL server.  Kerberos authentication would not work with Oracle or MySQL as I understand it.

  Thomas LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba