Is there a way to migrate the linked server from one server to another including the same password?
I don't have an old password.
Thanks!
Nirvesh
Is there a way to migrate the linked server from one server to another including the same password?
I don't have an old password.
Thanks!
Nirvesh
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
You can using Copy-DbaLinkedServer. Copy-DbaLinkedServer migrates Linked Servers from one SQL Server to another. Linked Server logins and passwords are migrated as well.
Refer to the blog Scripting Out Linked Servers with Actual Passwords.
We can also script out Linked Server on old server, then run the scripts in new server. But you need to manually key-in the passwords as when you script out linked servers, passwords are not scripted out - they are grabbled - ########. If the local login is not in your new server, you also need to add the login in your new server manually.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
17 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index