SAP Knowledge Base Article - Public

1442827 - error: Connect to message server failed using Crystal Reports 2008 with an SAP Bex Query

Symptom

When trying to use a data source of type SAP BW Query or SAP BW MDX Query in the Database Expert the error: "Connect to message server failed" is shown and no connection is possible. This error only occurs when using a message server.
When using an application server everything is working fine.

Environment

  • Crystal Reports 2008                                                                                
  • SAP GUI for Windows 7.10, Patch Level 15
  • SAP BW 7.0
  • Integration Kit for SAP 12.0. XI 3.1 SP2                                                                                      
                          

Cause

message server entry is missing in the "services" file which can be found in the following location /windows/system32/drivers/etc.

Resolution

The following entry must appear in the Services file on the BusinessObjects Enterprise machine (found in /etc):
sapmsSIDport/tcp

Please refer to SAP Integration kit install guide page 52.

Keywords

KBA , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1