Changing Linked Server Passwords

  • thomasliddledba

    Ten Centuries

    Points: 1190

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

    Thomas Liddle
    SQL Server Administrator
    Video Blog - YouTube
    Web Blog - www.thomasliddledba.com
    Twitter - @thomasliddledba
    Facebook - @thomasliddledba

  • vaa4

    SSC Journeyman

    Points: 80

    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: 1190

    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 Liddle
    SQL Server Administrator
    Video Blog - YouTube
    Web Blog - www.thomasliddledba.com
    Twitter - @thomasliddledba
    Facebook - @thomasliddledba

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply