I am pointing to the BizTalk Server and not the SQL Server (the SQL Server
doesnt have the BizTalk WMI namespaces). The SQL Server is set-up as
I did some further testing with WBEMTEST.EXE:
On my local Biztalk Server (DEVBIZTALK), I open WBEMTEST.EXE, connected to
root\MicrosoftBizTalkServer, ran the query:
SELECT * FROM MSBTS_HostInstance WHERE HostType =1
and I get the HostInstance.
Still on my local server I connect to the remote biztalk server (MELBIZTALK)
via WBEMTEST.EXE with \\melbiztalk\root\MicrosoftBizTalkServer, ran the same
query and I get the SQL error we are looking into.
To rule out SQL permissions, I then Remote Desktoped into MELBIZTALK, logged
in as the same user I was using on DEVBIZTALK, ran WBEMTEST.EXE, connected to
root\MicrosoftBizTalkServer, ran the query and it returned the HostInstance.
So it appears to be a remote WMI restriction for BizTalk... I can obtain
other WMI information remotely (ie Amount of memory the server has:
Any help appreciated.
"Anthony O" wrote: