1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. Problem connecting to Greenplum from SSAS

Problem connecting to Greenplum from SSAS

More
10 years 2 months ago #3180 by mnugroho001
Problem connecting to Greenplum from SSAS was created 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
Replied by Moderator on topic Re: Problem connecting to Greenplum from SSAS
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.

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. Problem connecting to Greenplum from SSAS
Time to create page: 0.053 seconds
Powered by Kunena Forum