Change PW for current Linked Server will break connection?

Question

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.

Answer 1

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.

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.

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.

Answer 2

Thanks Cathy for the reply, much appreciated.