Hi,

I am attempting to consume a BizTalk Orchestration exposed by the Web
services Publishing wizard.

I have exposed the web service and for the purposes of testing I have
configured the IIS Virtual Directory to use Anonymous access with the same
account configured that BizTalk runs under.

The web service accepts the message ok but I get the following error in the
event log:


An attempt to connect to "BizTalkMgmtDb" SQL Server database on server
"EDXP5364" failed with error: "Cannot open database requested in login
'BizTalkMgmtDb'. Login fails.".

The account I am trying to connect with is a fully privilaged account on the
machine, so there is no reason here why this should not connect.

Only reason I can see for this is that the account everything is running
under belongs to a trusted domain, and not the domain my development PC is
running under. BizTalk, SQL Server and everything else though is installed
and running fine under this account from the trused domain. (We have a
business domain and a development domain but we only have accounts on the
business domain).

I've tried running the web service under a local machine account that has
full privilages but this yields the same error.

Help would be very much appreciated!

Thanks

Campbell.

www.katena.co.uk

[ Post a follow-up to this message ]

When you reach over to the Sql Server, you'll (almost always) be using the
process-level credentials (which will likely flow from your app pool
configuration.)  Make sure that account is in the isolated host users group.

Scott Colestock
www.traceofthought.net

"Campbell McNeill." <Campbell McNeill.@discussions.microsoft.com> wrote in
message news:DF620CA0-8F93-4B9F-BEEA-9EA58BE29D27@microsoft.com...
> Hi,
>
> I am attempting to consume a BizTalk Orchestration exposed by the Web
> services Publishing wizard.
>
> I have exposed the web service and for the purposes of testing I have
> configured the IIS Virtual Directory to use Anonymous access with the same
> account configured that BizTalk runs under.
>
> The web service accepts the message ok but I get the following error in
> the
> event log:
>
>
> An attempt to connect to "BizTalkMgmtDb" SQL Server database on server
> "EDXP5364" failed with error: "Cannot open database requested in login
> 'BizTalkMgmtDb'. Login fails.".
>
> The account I am trying to connect with is a fully privilaged account on
> the
> machine, so there is no reason here why this should not connect.
>
> Only reason I can see for this is that the account everything is running
> under belongs to a trusted domain, and not the domain my development PC is
> running under. BizTalk, SQL Server and everything else though is installed
> and running fine under this account from the trused domain. (We have a
> business domain and a development domain but we only have accounts on the
> business domain).
>
> I've tried running the web service under a local machine account that has
> full privilages but this yields the same error.
>
> Help would be very much appreciated!
>
> Thanks
>
> Campbell.
>
> www.katena.co.uk
>

[ Post a follow-up to this message ]