Connection to Local Server could not be established.

[SiegelEricR]

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?

[SASKiwi]

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

[SiegelEricR]

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).

[SASKiwi]

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.

[SiegelEricR]

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

[Kurt_Bremser]

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)?

[SiegelEricR]

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.

[BStone]

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.

[SiegelEricR]

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

[Patrick]

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.

[BStone]

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

[JohnB · Accepted solution]

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.