|
Home > Archive > BizTalk Server Orchestration > March 2004 > Calling published orchestartion
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calling published orchestartion
|
|
| Oleg Kleyman 2004-03-21, 1:36 pm |
| Hi,
I'm trying to invoke the published orchestartion from
my .aspx client. The call failed, however, with the
following message in Event Log:
"An attempt to connect to "BizTalkMgmtDb" SQL Server
database on server "xxx" failed with error: "Login failed
for user 'NT AUTHORITY\NETWORK SERVICE'."
I'm running under Win2003, so it seems that ASP.NET
account (named there NETWORK SERVICE) is a problematic,
but what it does with BTS Management Database.
Impersonating from web.config doesn't help - I give the
same error.
Any help will be appreciated. Thanks in advance.
Oleg Kleyman. okey@netvision.net.il
| |
| Tomas Restrepo \(MVP\) 2004-03-21, 2:35 pm |
| Oleg,
> I'm trying to invoke the published orchestartion from
> my .aspx client. The call failed, however, with the
> following message in Event Log:
> "An attempt to connect to "BizTalkMgmtDb" SQL Server
> database on server "xxx" failed with error: "Login failed
> for user 'NT AUTHORITY\NETWORK SERVICE'."
> I'm running under Win2003, so it seems that ASP.NET
> account (named there NETWORK SERVICE) is a problematic,
> but what it does with BTS Management Database.
> Impersonating from web.config doesn't help - I give the
> same error.
BizTalk uses Integrated security to connect to the BizTalk DBs. What I
usually do is create a special account I use to run BizTalk services, then
in WinServer 2003 create a new IIS Application Pool running under said
account, then map the web applications acting as SOAP receivers and whatnot
to run under said application pool.
--
Tomas Restrepo
tomasr@mvps.org
| |
| easwar anand 2004-03-22, 6:35 am |
| Tomas,
I got the same error on my Win XP machine. I can't create
application pools in IIS running on XP, right? How do I
workaround this problem then?
Thanks,
e.a
>-----Original Message-----
>Oleg,
>
failed[color=darkred]
>
>BizTalk uses Integrated security to connect to the
BizTalk DBs. What I
>usually do is create a special account I use to run
BizTalk services, then
>in WinServer 2003 create a new IIS Application Pool
running under said
>account, then map the web applications acting as SOAP
receivers and whatnot
>to run under said application pool.
>
>--
>Tomas Restrepo
>tomasr@mvps.org
>
>
>.
>
| |
| Oleg Kleyman 2004-03-22, 7:36 am |
| Thanks a lot. It's working.
>-----Original Message-----
>Oleg,
>
failed[color=darkred]
>
>BizTalk uses Integrated security to connect to the
BizTalk DBs. What I
>usually do is create a special account I use to run
BizTalk services, then
>in WinServer 2003 create a new IIS Application Pool
running under said
>account, then map the web applications acting as SOAP
receivers and whatnot
>to run under said application pool.
>
>--
>Tomas Restrepo
>tomasr@mvps.org
>
>
>.
>
| |
| Oleg Kleyman 2004-03-22, 7:36 am |
| Under WinXP, you aspx application running under ASPNET
account. So try to grant the DB permitions to it : add the
SQLServer logon for ASPNET and permit it to access BTS
databases, or better yet, include ASPNET accont
into "BizTalk Application Users" NT group.
>-----Original Message-----
>Tomas,
>
>I got the same error on my Win XP machine. I can't create
>application pools in IIS running on XP, right? How do I
>workaround this problem then?
>
>Thanks,
>e.a
>
>failed
>BizTalk DBs. What I
>BizTalk services, then
>running under said
>receivers and whatnot
>.
>
| |
| Tomas Restrepo \(MVP\) 2004-03-22, 8:37 am |
| > Tomas,
>
> I got the same error on my Win XP machine. I can't create
> application pools in IIS running on XP, right? How do I
> workaround this problem then?
Oleg already provided one option. The other one is to run the full ASP.NET
under another account, one that does have access, by modifying the
processModel entry in machine.config.
--
Tomas Restrepo
tomasr@mvps.org
|
|
|
|
|