Problem connecting to Greenplum from SSAS

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Problem connecting to Greenplum from SSAS

Postby mnugroho001 » Wed Oct 26, 2011 2:29 am

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
Error connecting to Greenplum from SSAS.png
Error connecting to Greenplum from SSAS.png (34.36 KiB) Viewed 3831 times
mnugroho001
 
Posts: 1
Joined: Thu Oct 20, 2011 11:23 pm

Re: Problem connecting to Greenplum from SSAS

Postby Moderator » Wed Oct 26, 2011 3:57 pm

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.
User avatar
Moderator
Site Admin
 
Posts: 305
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 4 guests

cron