SQL WinHttp.WinHttpRequest https request error

332 Views Asked by At

How to ignore SSL error (0x80072F7D) in SQL WinHttp.WinHttpRequest HTTPS request?

EXEC @hr = sp_OASetProperty @win, 'Option' , '&H3300','4'
EXEC @hr = sp_OASetProperty @win, 'Option' , 13056,4

Still the same error 0x80072F7D

1

There are 1 best solutions below

0
Maciej Rubinkiewicz On

The solution is to declare a proper SSL protocol. 2048 is TLS 1.2.

EXEC @hr=sp_OASetProperty @win, 'Option', 2048, 9

...and/or install Microsoft SQL Server TLS 1.2 update KB3135244.