Change PW for current Linked Server will break connection?

techresearch7777777 1,766 Reputation points
2020-11-30T23:33:16.9+00:00

Hello we have an active live SQL Server [Linked Server]

If the PW that it's currently uses gets changed on the remote server will it break/cause disruption to the current connection for this Linked Server?

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,662 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2020-12-01T02:22:53.673+00:00

    Hi @techresearch7777777 ,

    > If the PW that it's currently uses gets changed on the remote server will it break/cause disruption to the current connection for this Linked Server?

    Yes. I test it in my environment, the link server connection will failed as below screenshot when you change password of the remote server login that used in linked server in remote server. Then you need to change the password of remote login in SQL server Properties as below screenshot to make linked server work well.

    43873-screenshot-2020-12-01-100850.jpg
    43777-screenshot-2020-12-01-101006.jpg
    43951-screenshot-2020-12-01-101517.jpg

    If the linked server is configured with mapped local logins, you will need to change the password of remote login that is mapped for each local login as below screenshot.

    43847-screenshot-2020-12-01-101412.jpg

    By the way, we can also using T-SQL to change the password of remote login used in linked server. Please refer to this blog Changing Linked Server Passwords to get more details information.

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it.


1 additional answer

Sort by: Most helpful
  1. techresearch7777777 1,766 Reputation points
    2020-12-02T18:18:22+00:00

    Thanks Cathy for the reply, much appreciated.

    0 comments No comments