|
Home > Archive > BizTalk Server > December 2004 > An attempt to connect to "BizTalkMgmtDb" SQL Server database on se
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 |
An attempt to connect to "BizTalkMgmtDb" SQL Server database on se
|
|
| Patrice Calve 2004-10-26, 5:48 pm |
| Hi,
We have a recurring problem since a few days...
Note: Biztalk and SQL server are on their own (separate) server. The BTS
Service runs as a local account. Both servers have the same groups and
accounts (including the 3 BTS groups)
Here it is: BizTalk reports that it can't reach it's BTS internal Database
with an error like this:
Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 6913
Date: 10/26/2004
Time: 3:31:38 PM
User: N/A
Computer: BTSServer
Description:
An attempt to connect to "BizTalkMgmtDb" SQL Server database on server
"BTSSQL" failed with error: "Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.".
Here's what I found so far. Since the 18th of october, it has done it 4
times:
2004.10.18 15:55:42 Duration 12:51 hours
2004.10.20 08:42:15 Duration 00:30 hours
2004.10.21 10:56:55 Duration 07:56 hours
2004.10.26 11:43:28 Still not responding
HAT works. My guess is that HAT queries the Database directly.
I looked up both servers (BizTalk and SQL) and both event logs (Server and
Application) and found NOTHING close to be related to the problem.
I looked up the archive files and no file in that period seemed unusual.
Worst than that, the archive folder indicates that there were files processed
by BizTalk !!! WTH did BizTalk do with those messages then?
There's an anti-virus running but scan's log on the BizTalk box but found
nothing.
I have no clue where to look any further.
Pat
| |
| Anthony O 2004-12-13, 6:28 pm |
| Pat,
A few things I would suggest are as follows:
--What service is using the account 'NT AUTHORITY\ANONYMOUS' as specified
in your question
-- I suspect the account that you configure to run your application pool is
the suspect.
--Change this account to a valid login account, and also verify that the
account you specify has permission to the
BizTalk databases
Also verify that
--The Isolated host and Isolated Host accounts belong to the Isolated Host
groups.
Let me know if you need further help.
Anthony O.
"Patrice Calve" <Patrice Calve@discussions.microsoft.com> wrote in message
news:629F1557-C583-4876-AC28-6201D0A20631@microsoft.com...
> Hi,
>
> We have a recurring problem since a few days...
>
> Note: Biztalk and SQL server are on their own (separate) server. The BTS
> Service runs as a local account. Both servers have the same groups and
> accounts (including the 3 BTS groups)
>
> Here it is: BizTalk reports that it can't reach it's BTS internal Database
> with an error like this:
>
> Event Type: Error
> Event Source: BizTalk Server 2004
> Event Category: BizTalk Server 2004
> Event ID: 6913
> Date: 10/26/2004
> Time: 3:31:38 PM
> User: N/A
> Computer: BTSServer
> Description:
> An attempt to connect to "BizTalkMgmtDb" SQL Server database on server
> "BTSSQL" failed with error: "Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.".
>
>
> Here's what I found so far. Since the 18th of october, it has done it 4
> times:
> 2004.10.18 15:55:42 Duration 12:51 hours
> 2004.10.20 08:42:15 Duration 00:30 hours
> 2004.10.21 10:56:55 Duration 07:56 hours
> 2004.10.26 11:43:28 Still not responding
>
>
> HAT works. My guess is that HAT queries the Database directly.
>
> I looked up both servers (BizTalk and SQL) and both event logs (Server and
> Application) and found NOTHING close to be related to the problem.
>
> I looked up the archive files and no file in that period seemed unusual.
> Worst than that, the archive folder indicates that there were files
processed
> by BizTalk !!! WTH did BizTalk do with those messages then?
>
> There's an anti-virus running but scan's log on the BizTalk box but found
> nothing.
>
> I have no clue where to look any further.
>
> Pat
|
|
|
|
|