|
Home > Archive > BizTalk Server Setup > November 2005 > Local System Account access denied to SSODB
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 |
Local System Account access denied to SSODB
|
|
| BizRookie 2005-11-28, 6:02 pm |
| First, here is what I have set up...
1. An oracle 9.2.1.6 instance on W2k3 with Oracle COM Automation Feature
configured to call local COM interfaces from Oracle PL/SQL procedures.
2. An Oracle listener running under the Local System Account that allows
these COM interface calles via an oracle process called extproc.exe
3. Biztalk Server 2004 on the same instance with
Microsoft.BizTalk.IInterchange.dll registered.
From an Oracle stored procedure, I attempt to send an XML document to the
Biztalk runtime via the Submit function of the IInterchange COM interface and
receive an application log error that tells me SSO Audit call to
GetConfigInfo failed, access is denied. Basically this says that the user,
the Local System Account running the Oracle extproc listener, does not have
access to the SSODB database. How do I grant SSODB access in SQL Server to
the Local System Account? I tried adding Local System Account to the SSO
Administrators group and even made the Local System Account a DBOWNER of the
SSODB database and still was not successful. This worked fine in Biztalk
2002 when SSO was not in the mix.
| |
| Yuan Ren[MSFT] 2005-11-29, 7:49 am |
| Hi,
Welcome to MSDN newsgroup!
Since I have no Oracle environment to do the same test, I can not reproduce
your problem. From your description, it seems the local system don¡¯t have
the permission. Based on my experience, the better way is changing another
account to do the same test. Before testing, please make sure the account
is included into the BizTalk Isolated Host Users group, IIS_WPG group and
the SSO Administrator group by configured in the computer management tool.
If the error also occurred, I wonder whether there was some detail
information in the event log. If there is, please attach the information to
me.
I¡¯m looking forward your reply!
Regards,
Yuan Ren [MSFT]
Microsoft Online Support
| |
| BizRookie 2005-11-29, 5:55 pm |
| Thanks for the response...
As you suggest, I am able to successfully run the same test as another user.
I did this in two ways, by referencing the IInterchange component from
within a C# console app and by using the CreateObject method within a VB
script. Both of these methods successfully submit the XML to Biztalk as this
user. I even have made the local system account a member of the local
Administrators group and still access is denied to SSODB.
""Yuan Ren[MSFT]"" wrote:
> Hi,
>
> Welcome to MSDN newsgroup!
>
> Since I have no Oracle environment to do the same test, I can not reproduce
> your problem. From your description, it seems the local system don¡¯t have
> the permission. Based on my experience, the better way is changing another
> account to do the same test. Before testing, please make sure the account
> is included into the BizTalk Isolated Host Users group, IIS_WPG group and
> the SSO Administrator group by configured in the computer management tool.
>
> If the error also occurred, I wonder whether there was some detail
> information in the event log. If there is, please attach the information to
> me.
>
> I¡¯m looking forward your reply!
>
> Regards,
>
> Yuan Ren [MSFT]
> Microsoft Online Support
| |
| Yuan Ren[MSFT] 2005-11-30, 7:57 am |
| Hi,
Thanks for your posting!
> "I am able to successfully run the same test as another user."
I assume you use the domain account, it this true?
>"1. An oracle 9.2.1.6 instance on W2k3 with Oracle COM Automation Feature
configured to call local COM interfaces from Oracle PL/SQL procedures.
2. An Oracle listener running under the Local System Account that allows
these COM interface calles via an oracle process called extproc.exe
3. Biztalk Server 2004 on the same instance with
Microsoft.BizTalk.IInterchange.dll registered."
Actually, I have a little confusion about the function you want to
implement. Could you give me some detail description?
Otherwise, I think the SSODB and the BizTalk Server is not installed in the
same machine, is it? Could you provide some details about the current
environment? It will give me more help about the current issue.
Thanks for your understanding! I'm looking forward your reply.
Yuan Ren [MSFT]
Microsoft Online Support
| |
| BizRookie 2005-11-30, 5:52 pm |
| Thanks for your time on this matter to this point. As time is growing short
for me on this project, I have had to burn one of my MSDN subscription
service calls to Microsoft. A Microsoft engineer has been assigned and is
working on this issue for me.
""Yuan Ren[MSFT]"" wrote:
> Hi,
>
> Thanks for your posting!
>
> I assume you use the domain account, it this true?
>
> configured to call local COM interfaces from Oracle PL/SQL procedures.
> 2. An Oracle listener running under the Local System Account that allows
> these COM interface calles via an oracle process called extproc.exe
> 3. Biztalk Server 2004 on the same instance with
> Microsoft.BizTalk.IInterchange.dll registered."
> Actually, I have a little confusion about the function you want to
> implement. Could you give me some detail description?
>
> Otherwise, I think the SSODB and the BizTalk Server is not installed in the
> same machine, is it? Could you provide some details about the current
> environment? It will give me more help about the current issue.
>
> Thanks for your understanding! I'm looking forward your reply.
>
> Yuan Ren [MSFT]
> Microsoft Online Support
|
|
|
|
|