How to automatically change linked server password

Question

How to automatically change linked server password

ora 21

Olaf Helper 47,516 Reputation points

2024-06-18T10:39:16.18+00:00

And how could an "automatic" know the new password for which login?
ora 21 Reputation points

2024-06-18T14:32:21.0233333+00:00

Few blogs suggested to write a PowerShell script and call job for a login to update.
ora 21 Reputation points

2024-06-18T14:33:39.13+00:00

I am looking if any possible solutions are already available.
LiHongMSFT-4306 31,576 Reputation points

2024-06-19T01:48:57.8833333+00:00

Few blogs suggested to write a PowerShell script and call job for a login to update.

Not sure if it is safe enough, cause PowerShell scripts may leave logs or history during execution, which can be exploited by malicious users if not properly managed.

2 answers

Your answer

Olaf Helper 47,516 Reputation points

2024-06-18T10:39:16.18+00:00

And how could an "automatic" know the new password for which login?
ora 21 Reputation points

2024-06-18T14:32:21.0233333+00:00

Few blogs suggested to write a PowerShell script and call job for a login to update.
ora 21 Reputation points

2024-06-18T14:33:39.13+00:00

I am looking if any possible solutions are already available.
LiHongMSFT-4306 31,576 Reputation points

2024-06-19T01:48:57.8833333+00:00

Few blogs suggested to write a PowerShell script and call job for a login to update.

Not sure if it is safe enough, cause PowerShell scripts may leave logs or history during execution, which can be exploited by malicious users if not properly managed.

Answer 1

Michael Taylor 60,346

This blog article talks about the T-SQL you need to run from PS to change a linked server password. Just call it from PS.

Note that changing a linked server's password will break existing linked server connections. So either do this outside the hours you're using the linked server or ensure the server's password is changed in both places really close together and not when the connection may be in use.

Answer 2

Olaf Helper 47,516

You didn't explain the logic for "new password for which login"?

If you want to use PowerShell, use the PowerShell CmdLet "DbaTools"

https://docs.dbatools.io/Get-DbaLinkedServer.html

Share via

How to automatically change linked server password

2 answers

Your answer