topic Re: Unable to connect to SAS Enterprise Guide Local Server in SAS Enterprise Guide

Unable to connect to SAS Enterprise Guide Local Server

ormis66 — Wed, 11 Jan 2017 15:59:45 GMT

Hello!,

I am new to SAS. I installed SAS EG 7.1 64 bit successfully 7 months on my desktop and it has been working fine until now. I am unable to connect to my local server. The follow error message is shown when I try to connect.

"An unexpected error has occurred". "A connection could not be made to the requested resource"

Please Help.

Thank you

Re: Unable to connect to SAS Enterprise Guide Local Server

JuanS_OCS — Wed, 11 Jan 2017 16:20:33 GMT

Hi @ormis66,

while I would say that the problem is that you don;t have a local SAS Foundation or your license expired, I would definetely click on see additional details...

Re: Unable to connect to SAS Enterprise Guide Local Server

ormis66 — Wed, 11 Jan 2017 16:30:03 GMT

So i clicked on "Additional Details" is what i found.

Problem report created: Wednesday, January 11, 2017 4:23:48 PM UTC

SAS Enterprise Guide
An unexpected error has occurred
A connection could not be made to the requested resource.

-------------------------------------------------------------------------------------------------------
Exception information
-------------------------------------------------------------------------------------------------------

Server execution failed

-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: SAS.EG.SDS.SDSException
Message:         Server execution failed

Source:          SAS.EG.SDS.Model
Target Site:     SASWorkspace

Stack Trace:
   at SAS.EG.SDS.Model.Server.SASWorkspace(Boolean checkWorkspace)
   at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op)

Inner Exception Details:
----------------------------------------
Exception type: SAS.EC.Directory.Model.SDSException
Message:         Server execution failed

Source:          EC.Directory
Target Site:     Connect

Inner Exception Details:
----------------------------------------
Exception type: System.Runtime.InteropServices.COMException
Message:         Server execution failed

Source:          SASObjectManager
Target Site:     CreateObjectByServer

Stack Trace:
   at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String Name, Boolean synchronous, IServerDef pIServerDef, String LoginName, String Password)
   at SAS.EC.Directory.Model.Server.Connect(ConnectionInfo connInfo)

--------------------------------------------------------------------------------------------------------
Configuration Details
--------------------------------------------------------------------------------------------------------

Re: Unable to connect to SAS Enterprise Guide Local Server

TomKari — Wed, 11 Jan 2017 17:17:04 GMT

If you have the ability to just run SAS, do that. The initialization messages might be useful.

For instance, it used to be that if the license had expired for SAS, EG would just fail and not provide any useful diagnostics.

Re: Unable to connect to SAS Enterprise Guide Local Server

ormis66 — Wed, 11 Jan 2017 17:40:17 GMT

Hi TomKeri,

Is there a definite way to check if the license has expired? The license is suppored to be for a year.

Thank you

Re: Unable to connect to SAS Enterprise Guide Local Server

AhmedAl_Attar — Wed, 11 Jan 2017 18:36:49 GMT

Hi,

Upon trying to start SAS, if your license had expired, you'll get notified immediatly, and your process terminates.

Ahmed

Re: Unable to connect to SAS Enterprise Guide Local Server

CaseySmith — Wed, 11 Jan 2017 19:25:52 GMT

I agree with the suggestion of first trying to open your local SAS directly (ex. Start->All Programs->"SAS 9.4 (<language>)"). If it doesn't work, there is your problem.

However, if you are able to start and use local SAS fine outside of EG, but still fails to connect to Local server from within EG, then I suggest trying to re-register your local SAS by running these commands from a command window:

C:\Program Files\SAS\SASFoundation\9.4\sas.exe -unregserver

C:\Program Files\SAS\SASFoundation\9.4\sas.exe -regserver

If that doesn't fix the problem, then use the Integration Technologies Configuration Wizard utility (C:\Program Files\SASHome\x86\Integration Technologies\ITConfig2.exe) to test a local server connection ("Test SAS Servers"->"Enter a SAS server definition manually"->ensure Currently Testing set to "SAS Workspace Server"->set connection Protocol to "COM" and press "Test" button.).

Re: Unable to connect to SAS Enterprise Guide Local Server

ccaulkins9 — Thu, 12 Jan 2017 15:33:36 GMT

Omri -
Are you certain that the "local server" or the Metadata Server is up and running? A screenshot could be worth a thousand words in this case, but if your license is good for a year then you should check that the system (platform?) is functioning properly.

Re: Unable to connect to SAS Enterprise Guide Local Server

ormis66 — Thu, 12 Jan 2017 20:47:38 GMT

Hi Casy,

The SAS message Log confirmed that the license has expired. I have contacted my SAS Installation representative. Thanks a million.

Re: Unable to connect to SAS Enterprise Guide Local Server

shilpaISBCBA — Thu, 31 May 2018 10:04:14 GMT

HEllo,

I have the same issue and when I tried reregistering the server I get the error message in the message log "membership in administrators is not present"

What could this mean?

I have attached the stack trace of the issue.

Re: Unable to connect to SAS Enterprise Guide Local Server

ccaulkins9 — Thu, 31 May 2018 14:50:13 GMT

Is this Windows or Linux?

Re: Unable to connect to SAS Enterprise Guide Local Server

ccaulkins9 — Thu, 31 May 2018 14:55:56 GMT

or as @ShelleySessoms and @Sas_Dummy are fond of saying if you found this track to be helpful you should consider opening posting it anew ...

Re: Unable to connect to SAS Enterprise Guide Local Server

ShelleySessoms — Thu, 31 May 2018 15:05:52 GMT

Yes, @shilpaISBCBA. @ccaulkins9 is correct. Your best bet is to post a new question with this information. It will get the attention of more folks, rather than posting to a solved question.

Best of luck,

Shelley

Re: Unable to connect to SAS Enterprise Guide Local Server

shilpaISBCBA — Fri, 01 Jun 2018 04:43:25 GMT

Opened a new thread. Many thanks!

https://communities.sas.com/t5/SAS-Enterprise-Guide/Unable-to-connect-to-SAS-Enterprise-Guide-Local-Server/m-p/466741#M30279

Re: Unable to connect to SAS Enterprise Guide Local Server

ccaulkins9 — Mon, 04 Jun 2018 15:02:01 GMT

see the log - Windows, I'm pretty sure given that it's EG