Problem connecting to Greenplum from SSAS

More
10 years 2 months ago #3180 by mnugroho001
Hi All,

I am working on a project and use SSAS for Analysis Service.
I tried to connect to Greenplum from SSAS using PGNP OLEDB driver, but failed.

When trying to create a new connection from our OLAP server (SSAS - SQL Server Analysis Service) to Greenplum,
I got the following error message (see attached).

Is there anyone got similar problem? Any prompt suggestion will be appreciated :)
Thank you

Regards,

Marcus[attachment=0:2awdbvaf]<!-- ia0 -->Error connecting to Greenplum from SSAS.png<!-- ia0 -->[/attachment:2awdbvaf]
Attachments:

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #3186 by Moderator
This could be caused by the firewall. Could you disable the firewall temporarily and see if connection works?

Could you check that pg_hba.conf contains entries to accept remote connections from IPv4 and IPv6 addresses?

Please read Greenplum logs to see if connection attempt was made and why it was rejected.

Please also double check the connection parameters.

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum