Forum Discussion

JackiePan's avatar
JackiePan
New Member
7 years ago

SAP BW Message server connection failed

HI,

  We are trying to use SAP Connector 3.0 to link PowerBI with our BW system. 

But throwing the below message. Any idea on this? 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello,

    I have a similar problem :

     

    Details: "SAP Business Warehouse:
    ERROR service 'sapmsPBG' unknown
    TIME Tue Jun 11 11:18:07 2019
    RELEASE 721
    COMPONENT NI (network interface)
    VERSION 40
    RC -3
    MODULE ninti.c
    LINE 933
    DETAIL NiPGetServByName: 'sapmsPBG' not found
    SYSTEM CALL getaddrinfo
    COUNTER 1

     

    Can someone help ?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi JackiePan,

     

    I think it requires a new entry in the services file located at C:\Windows\System32\Drivers\etc

     

    It normally has the following form:

    sapms<SID> <port of message server>/tcp

    <port of message server> is per standard 36<instance number>

     

    E. g. if the SID of your SAP system is "PBG" and instance number is 10, the following entry needs to be added:

    sapmsPBG 3610/tcp

     

    Best regards,

    Philipp

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    We have a similar situation. Now as a quick solution the sapms<SID> messageserverPort/tcp needs to be added to the services file, but we have quite many users using the powerbi desktop and we cannot tell each user to maintain this entry, is there any other way to over come this ?

     

    Regards