Failure to copy Linked Servers in SQL 2025 #10205
Unanswered
dennisa72295
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I ran into a problem with copying a linked server from SQL 2025 instance to another 2025 instance. I get: WARNING: [Copy-DbaLinkedServer] Failure | The parameter is incorrect. I discovered that the drivers have changed in 2025 and the SSMS gui to create linked servers doesn't necessarily work because of the need to set and additional parameter like this: EXEC master.dbo.sp_addlinkedserver
@server = N'MYServerName',
@srvproduct = N'MSOLEDBSQL',
@Provider = N'MSOLEDBSQL19',
@datasrc = N'MyServerName',
@provstr = N'Encrypt=Optional;TrustServerCertificate=Yes';
GO
I haven't tried the output from Export-DbaLinkedServer yet but it does have the command with the extra parameter provstr in it. Has anyone else run into this and is there a fix for it. I'm using version 2.7.20 of dbatools
Beta Was this translation helpful? Give feedback.
All reactions