Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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 "BizTalkEDIDb" requested by the login. The login failed. Login failed for user 'domain\user'.

↑ Back to the top


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.

↑ Back to the top


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:
    • EDI Interchange and Correlated ACK Status
    • Batch Status
    • Interchange Aggregation Report
    • Transaction Set Aggregation Report

↑ Back to the top


Keywords: KB942283, kbprb, kbtshoot, kbbts, kbbtshat

↑ Back to the top

Article Info
Article ID : 942283
Revision : 4
Created on : 10/25/2007
Published on : 10/25/2007
Exists online : False
Views : 415