sql-serveroledblinked-server

Create linkied server encrypted from sqlserver 2019 to 2008r2 using Microsoft OLE DB Driver 19 for SQL Server


I have som sql server 2008 r2 that I want to connect to it have force encryption set to NO and some expired certyficate

Now, from new sql server 2019 I want to make new linked server connection

So, I have

 EXEC master.dbo.sp_addlinkedserver @server = N'PB01_ENC2', @srvproduct=N'mssqlserver', @provider=N'MSOLEDBSQL19', @datasrc=N'PB01', @provstr=N'TrustServerCertificate=True;Encrypt=false;'

and this add linkedserver fine hoever when i want connect i get enter image description here

why is that? i known that cert expired but TrustServerCertificate=True should handle this ? or in Microsoft OLE DB Driver 19 for SQL Server it need to be specified somehow diferent?

Encrypt=true; does not change anyhing here...

please advise best regards


Solution

  • for future searcherchers - i sow someone was posting here yesturday but deleted because of votedown

    IT IS BUG IN MICROSOFT CLIENT to resolve this we need to add User ID=anything'

    so finaly like

    @provstr=N'Encrypt=yes;TrustServerCertificate=yes;User ID=myUser'

    and this solves this issue.