Desktop productivity for business analysts and programmers

Connection to Local Server could not be established.

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Connection to Local Server could not be established.

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?


Accepted Solutions
Solution
‎08-29-2017 09:26 AM
SAS Employee
Posts: 9

Re: Connection to Local Server could not be established.

[ Edited ]

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.

 

View solution in original post


All Replies
Super User
Posts: 3,238

Re: Connection to Local Server could not be established.

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

screenshot5.jpg

Occasional Contributor
Posts: 5

Re: Connection to Local Server could not be established.

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

SAS EG connections 20141105.PNG

SAS EG metadata server 20141105.PNG

Super User
Posts: 3,238

Re: Connection to Local Server could not be established.

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.

Occasional Contributor
Posts: 5

Re: Connection to Local Server could not be established.

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

Super User
Posts: 7,461

Re: Connection to Local Server could not be established.

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 5

Re: Connection to Local Server could not be established.

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.

Contributor
Posts: 30

Re: Connection to Local Server could not be established.

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.

Occasional Contributor
Posts: 5

Re: Connection to Local Server could not be established.

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

Respected Advisor
Posts: 4,137

Re: Connection to Local Server could not be established.

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.

Contributor
Posts: 30

Re: Connection to Local Server could not be established.

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

Solution
‎08-29-2017 09:26 AM
SAS Employee
Posts: 9

Re: Connection to Local Server could not be established.

[ Edited ]

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.

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 11 replies
  • 14471 views
  • 7 likes
  • 6 in conversation