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
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
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.