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