SQL Server SQL WinHttp.WinHttpRequest https request error

m1m5dgzv  于 2023-03-07  发布在  其他
关注(0)|答案(1)|浏览(123)

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

e5njpo68

e5njpo681#

The solution is to declare proper SSL prococol. 2048 is TLS 1.2. EXEC @hr=sp_OASetProperty @win, 'Option', 2048, 9 and/or install MSSQL TLS 1.2 update KB3135244.

相关问题