topic Connection to cube in Administration and Deployment

Connection to cube

Evelina — Mon, 26 Jun 2017 12:55:31 GMT

Hi,

When I try to connect to the OLAP server in SAS EG, I'm getting this error:

ERROR: The Bridge Protocol Engine Socket Access Method was unable to connect to host abc.net, port 5451.
ERROR: The TCP/IP tcpSockConnect() support routine failed with error 110 (The connection has timed out.)

What is the problem?

(This question is not related to programming but here is the code:

proc sql;
         connect to olap (host="abc.net" port=5451
                          user="***" password="***");
         
         disconnect from olap;
       quit;

)

Thanks.

Re: Connection to cube

Kurt_Bremser — Mon, 26 Jun 2017 13:00:17 GMT

Check if the OLAP server is up on host abc.net.

On UNIX, I'd issue

ps -ef|grep OLAP

from the commandline as the simplest method. But you can of course use the SAS Management Console to test the server. (expand Server Manager Plug-In, expand SASApp, right-click SASApp - Logical OLAP server, select "Verify")

Re: Connection to cube

anja — Mon, 26 Jun 2017 13:45:37 GMT

Hi,

is this the complete error message or is there more? Is there anything in the OLAP Server log?

See: config dir\Lev1\SASApp\OLAPServer\Logs.

Have you tried restarting the OLAP Server?

Did this ever work before?

Thanks

Anja

Re: Connection to cube

Evelina — Mon, 26 Jun 2017 15:20:52 GMT

I don't have access to logs on server.

But one question that in order to connect to OLAP cubes from SAS should 'SAS/ACCESS interface to OLE DB' be installed on server?