- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- Problem connecting to Greenplum from SSAS
Problem connecting to Greenplum from SSAS
- mnugroho001
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
10 years 9 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]
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]
Please Log in or Create an account to join the conversation.
10 years 9 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.
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.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- Problem connecting to Greenplum from SSAS
Time to create page: 0.054 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- Problem connecting to Greenplum from SSAS