Microsoft KB Archive/942283

= Error message when you try to view EDI reports in the HAT tool in BizTalk Server 2006 R2: &quot;An error occurred in accessing the EDI database&quot; =

Article ID: 942283

Article Last Modified on 10/25/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2006 R2 Standard Edition
 * Microsoft BizTalk Server 2006 R2 Enterprise Edition
 * Microsoft BizTalk Server 2006 R2 Developer Edition
 * Microsoft BizTalk Server 2006 R2 Branch Edition

-



SYMPTOMS
When you try to view Electronic Data Interchange (EDI) reports in the Health and Activity Tracking (HAT) tool in Microsoft BizTalk Server 2006 R2, you may receive an error message that resembles the following:

Health and Activity Tracking

An error occurred in accessing the EDI database. Make sure that SQL Server is running and that you have network connectivity to the server and that you have rights to access the database.

Cannot open database &quot;BizTalkEDIDb&quot; requested by the login. The login failed. Login failed for user ' '.



CAUSE
The BizTalkEDIDb database is not created when you perform a clean installation of BizTalk Server 2006 R2 and then configure BizTalk Server. However, the link to view EDI reports may still be present in the HAT tool.



WORKAROUND
To work around this issue, use the BizTalk Server 2006 Administration Console Group Hub to view EDI and AS2 reporting data. To do this, follow these steps:
 * 1) Start the BizTalk Server 2006 Administration Console.
 * 2) Expand BizTalk Server Administration, and then click the group that you want.
 * 3) In the EDI Status Reports section of the Group Hub page, click one of the following links:
 * 4) * EDI Interchange and Correlated ACK Status
 * 5) * Batch Status
 * 6) * Interchange Aggregation Report
 * 7) * Transaction Set Aggregation Report

Keywords: kbbtshat kbbts kbtshoot kbprb KB942283

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.