Soap Web Service Not Working With WINDOWS SERVER 2012

[SmurofNeves]

I hope someone can assist.

I am trying download a hotfix for server 2012 to solve the SOAP issue I have, when I execute code that works perfectly on other OS versions on SERVER 2012 it fails with: 0x80070057 The parameter is incorrect. Send failed POST.

I download the hotfix for 2012 here, but it does not install on my server and states incompatible.

https://support.microsoft.com/en-us...-server-communicates-to-a-web-server-using-st

I have tried changing the TSQL a little on my SP's but to no avail, found that here:

How to fix MSXML2.XMLHTTP and MSXML2.ServerXMLHttp Error 0x80070057 - The Parameter is Incorrect

If you found this post it probably means that you are experiencing the following scenario: A Windows 2012 or Windows 2016 Server machine with SQL Server 20

www.ryadel.com

I have also tired using the following, they all present errors:

--WinHttp.WinHttpRequest.5.1
--MSXML2.ServerXMLHTTP
--MSXML2.ServerXMLHTTP.4.0
--MSXML2.ServerXMLHTTP.3.0
EXEC @hResult = sp_OACreate 'MSXML2.ServerXMLHTTP.3.0', @objectID OUT

The supposed working TSQL change that did not work:

----OLD METHOD
--DECLARE @parms AS varchar(3000) = 'p1=a&p2=b&p3=c';
----EXEC @result = sp_OAMethod @obj, 'send', NULL, @parms;

----NEW METOHD
--DECLARE @parms AS varchar(3000) = 'p1=a&p2=b&p3=c';
--DECLARE @send NVARCHAR(4000) = 'send("' + REPLACE(@parms, '"', '''') + '")';
----EXEC @result = sp_OAMethod @obj, @send;

I have sorted out one of our 2012 servers by copying the msxml3.dll and msxml6.dll from another 2008 server, but doing to same does not work on this server, I need the correct dll's to succeed.

Any suggestions please.

Thank you, help is appreciated.

Continue reading...