topic Re: Connection to Local Server could not be established. in SAS Enterprise Guide

Connection to Local Server could not be established.

SiegelEricR — Wed, 05 Nov 2014 23:49:28 GMT

Hello. My SAS EG component was recently upgraded from 4.3 to 6.1 as part of the SAS installation on my desktop being upgraded from 9.3 to 9.4. I wish to access libraries that contain permanent SAS data sets. To do so, I typically run a Libname statement. When I try to run a Libname statement in the upgraded SAS EG, I get the following message: A connection to the server "Local" could not be established. This never was a problem in SAS EG before the upgrade. What can I do to fix this problem?

Re: Connection to Local Server could not be established.

SASKiwi — Thu, 06 Nov 2014 01:54:38 GMT

In your EG connection profile try selecting the option to attach local servers to server list if available.

Re: Connection to Local Server could not be established.

SiegelEricR — Thu, 06 Nov 2014 03:34:37 GMT

The option was not available (first image below). Additionally, when I try to establish a profile for myself and set it active, it says Unable to connect to the metadata server (second image below).

Re: Connection to Local Server could not be established.

SASKiwi — Thu, 06 Nov 2014 03:47:29 GMT

Does that mean you only connect to SAS on your PC as your SAS server? If that is the case I would confirm that SAS 9.4 is correctly installed on your PC. Try starting SAS 9.4 directly from the Windows Start button.

Re: Connection to Local Server could not be established.

SiegelEricR — Thu, 06 Nov 2014 04:00:50 GMT

SAS 9.4 on my PC fires up just fine. All blue text, no green, no red.

Re: Connection to Local Server could not be established.

Kurt_Bremser — Thu, 06 Nov 2014 06:41:46 GMT

Foolish question, but:

Have you always worked with a single machine setup? Or was your former installation actually a 2/3 tiered setup with a remote server (metadata and workspace)?

Re: Connection to Local Server could not be established.

BStone — Thu, 06 Nov 2014 13:27:09 GMT

Run through the following SAS Note - http://support.sas.com/kb/45/258.html

After an upgrade of EG, you need to re-register (regserver) the server, that should resolve the issue. Make sure EG 6.1 is pointing to your local SAS Foundation.

The same note should apply to SAS 9.4 / EG 6.1

Re: Connection to Local Server could not be established.

SiegelEricR — Thu, 06 Nov 2014 17:46:23 GMT

At my primary workplace, I have always worked with a single-machine setup. With the previous installation, I never had to create a profile. I could always open localhost successfully, and I could run libname statements successfully to access permanent SAS datasets through folders created within localhost.

Re: Connection to Local Server could not be established.

BStone — Thu, 06 Nov 2014 22:26:34 GMT

Did you try re-registering the SAS server following that note?

Yes you don't need a profile, but EG needs SAS Foundation to run, if you are able to run the same Libname statement in SAS Foundation, than the issue is with EG not being able to find SAS Foundation.

Point is... Enterprise Guide needs SAS to run, whether it's via your local SAS Foundation or via a SAS Server sitting in South America.

Re: Connection to Local Server could not be established.

Patrick — Fri, 07 Nov 2014 02:27:35 GMT

To just use a local instance of Foundation SAS with SAS EG you can connect using "do not use a profile". If you want to use a metadata profile then you also need a SAS Metadata server and an Object Spawner installed and running - also on your local machine.

Re: Connection to Local Server could not be established.

SiegelEricR — Fri, 07 Nov 2014 02:33:57 GMT

Answer to BStone's question: Yes. And it worked.

To make it work, I had to download and install one of the SAS Integration Technologies clients for SAS 9.4. I chose an older one, but when it installed, it also upgraded to the newest one. Then, once the installation was complete, I returned to Installation Note 45258, the note the BStone pointed me to, and followed it from that point forward, substituting newer version numbers when applicable.

Now I can access Locahost, and access preexisting libraries therein, and create new libraries therein using libname statements written in code meant for SAS Foundation, and so on. So Yes, this definitely was a successful resolution to my problem.

Installation note 45258 - Errors occur in SAS® Enterprise Guide® 4.3 after you uninstall SAS® 9.2

Re: Connection to Local Server could not be established.

JohnB — Tue, 29 Aug 2017 13:26:49 GMT

Also take a look at http://support.sas.com/kb/58761 which is the latest EG/local connection SAS note available.

For more details, see Using SAS Enterprise Guide with your Local SAS installation.