Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLSer

0x800c0005 = Error 5 = Access Denied.
What has changed on the server?
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SammyBar" wrote:

> Hi all,
> We have a sp that sends http requests. It uses Microsoft XMLHTTP component
> that is part of XML pack that is standard with SQL Server 2000 SP3. For an
> unknown reason the XMLHTTP component started to fail raising the error:
> OLE Automation Error Information
> HRESULT: 0x800c0005
> I've seen this error in Visual Basic 6 when trying to create a component
> that is not well installed. But here this error is raised when creating th
e
> object but when sending the request:
> Exec @.nError = sp_OACreate 'Microsoft.XMLHTTP', @.iReq OUT
> If @.nError != 0
> Begin
> Select @.nError = Null
> Raiserror('sp_OACreate Microsoft.XMLHTTP FAILED! [sp_send_http]', 16, -1)
> Goto Fin
> End
> Exec @.nError = sp_OAMethod @.iReq, 'Open', NULL, 'POST', @.sUrl, false,
> @.sUser, @.sPassword
> If @.nError != 0
> Begin
> Raiserror('sp_OAMethod Open FAILED! [sp_send_http]', 16, -1)
> Goto Fin
> End
> Exec @.nError = sp_OAMethod @.iReq, 'send'
> If @.nError != 0
> Begin
> Raiserror('sp_OAMethod Send FAILED! [sp_send_http]', 16, -1)
> Goto Fin
> End
> then it goes well through sp_OACreate and sp_OAMethod "Open" calls.
> I reregister msxml.dll, msxml2.dll, msxml2.dll, and restarted the server b
ut
> it was useless.
> Looking around on the server logs the only suspected entry I've found was:
> SqlDumpExceptionHandler: Process 397 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
> * ---
--
> * Short Stack Dump
> * 09C73F85 Module(UNKNOWN+00000000)
> * 0066A220 Module(sqlservr+0026A220) (MSXMLThreadDetach+0000003D)
> * 00505DF1 Module(sqlservr+00105DF1) (clean_process+000000C6)
> * 0050611D Module(sqlservr+0010611D) (kill_proc+000000EE)
> * 00506513 Module(sqlservr+00106513) (logout+000001AC)
> * 005063D8 Module(sqlservr+001063D8) (release_srvproc+00000045)
> * 004270F9 Module(sqlservr+000270F9) (process_commands+000002A2)
> * 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
> * 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
> * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
> * 77E8B2D8 Module(KERNEL32+0000B2D8) (lstrcmpiW+000000B7)
> * ---
--
> It looks like after that the XMLHTTP doesn't works.
> Then my problem is to restore the XMLHTTP component to normal state. It ru
ns
> on a production server so the rules here are very strict. We cannot instal
l
> any new package there. So just reinstalling the xml package is the least
> desirable solution. I'd prefer just reregister the proper dlls but it look
s
> like reregistering msxml?.dll is not enought.
> What should I do?
> Should I register any other dll associated to msxml?.dll
> Any idea is welcomed
> Thanks in advance
> Sammy
>
>> 0x800c0005 = Error 5 = Access Denied.
!!!
Where did you find error codes?

> What has changed on the server?
Nothing. It is in the production server and it is forbidden to change
anything..., even security patches...|||> Where did you find error codes?
From an OS command prompt:
NET HELPMSG 5
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SammyBar" <sammybar@.gmail.com> wrote in message news:%23ZP6ykskFHA.3144@.TK2MSFTNGP12.phx.g
bl...
> !!!
> Where did you find error codes?
>
> Nothing. It is in the production server and it is forbidden to change
> anything..., even security patches...
>|||Hi
It is the standard COM error. After seeing the same ones for 10 years, you
generally get to know them.
You can strip the last 4 characters, and use them as Tibor Karaszi noted in
his post.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SammyBar" <sammybar@.gmail.com> wrote in message
news:%23ZP6ykskFHA.3144@.TK2MSFTNGP12.phx.gbl...
> !!!
> Where did you find error codes?
>
> Nothing. It is in the production server and it is forbidden to change
> anything..., even security patches...
>|||> What has changed on the server?
Ok, I found the error. Somebody activated a second NIC on the server and
that mangled the network routes. The server that was being requested was not
available by pinging. That is way the error was raising on the "send"
method.
Thanks you all for the hints
Best regards
Sammy

Error "-2147168246 (8004d00a)" Failed to Enlist on Calling Object'

I checked what suggested with
http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
LucaHi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca|||At the moment I'm out of office and I don't know exactly which MDAC version
I'm using on client & server side.
Anyway I'm not using ORACLE...my problem is with SQLServer...
Luca
"John Bell" wrote:
> Hi
> What about the other suggestions in the 191168 or
> http://support.microsoft.com/kb/193893/EN-US/
> Which version of MDAC are you using?
> Are you using Oracle?
> John
> "lalberti" <lalberti@.discussions.microsoft.com> wrote in message
> news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
> >I checked what suggested with
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> > The pingtest results are OK.
> > Is there any other check to do in order to solve this problem?
> > Thanks,
> > Luca
>
>|||I get the exact same error, only after applying SP1 to the Windows 2003
Server running our SQL Server 2000 SP3 database server. Transactions from
our Windows 2000 Server SP4 application server give the same exact error. It
is basically a VB application trying to connect to the application database.
Ping tests work fine. DTC tests fail with same error.
"John Bell" wrote:
> Hi
> What about the other suggestions in the 191168 or
> http://support.microsoft.com/kb/193893/EN-US/
> Which version of MDAC are you using?
> Are you using Oracle?
> John
> "lalberti" <lalberti@.discussions.microsoft.com> wrote in message
> news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
> >I checked what suggested with
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;191168.
> > The pingtest results are OK.
> > Is there any other check to do in order to solve this problem?
> > Thanks,
> > Luca
>
>

Error "-2147168246 (8004d00a)" Failed to Enlist on Calling Object'

I checked what suggested with
http://support.microsoft.com/defaul...b;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
LucaHi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/defaul...b;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca

Error "-2147168246 (8004d00a)" Failed to Enlist on Calling Object'

I checked what suggested with
http://support.microsoft.com/default...;en-us;191168.
The pingtest results are OK.
Is there any other check to do in order to solve this problem?
Thanks,
Luca
Hi
What about the other suggestions in the 191168 or
http://support.microsoft.com/kb/193893/EN-US/
Which version of MDAC are you using?
Are you using Oracle?
John
"lalberti" <lalberti@.discussions.microsoft.com> wrote in message
news:35588228-F89A-449C-ABE2-0E5DD12073C4@.microsoft.com...
>I checked what suggested with
> http://support.microsoft.com/default...;en-us;191168.
> The pingtest results are OK.
> Is there any other check to do in order to solve this problem?
> Thanks,
> Luca