topic SAP BW Message server connection failed in Report Server

SAP BW Message server connection failed

JackiePan — Wed, 13 Mar 2019 02:29:17 GMT

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?

Re: SAP BW Message server connection failed

Anonymous — Tue, 11 Jun 2019 16:38:58 GMT

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 ?

Re: SAP BW Message server connection failed

Anonymous — Wed, 19 Feb 2020 13:22:28 GMT

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

Re: SAP BW Message server connection failed

Anonymous — Tue, 24 Aug 2021 20:40:23 GMT

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