topic Re: SAS EG "Cant Connect to Local Server" in SAS Enterprise Guide

SAS EG "Cant Connect to Local Server"

tejjoshi — Sun, 18 Aug 2013 12:48:30 GMT

I am getting the following error while trying to connect to the local SAS Server through EG:

Unable to cast COM object of type 'System.__ComObject' to interface type 'SAS.IWorkspace'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{440196D0-90F0-11D0-9F41-00A024BB830C}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

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

Exception Details:

----------------------------------------

Exception type: SAS.EG.SDS.SDSException

Message: Unable to cast COM object of type 'System.__ComObject' to interface type 'SAS.IWorkspace'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{440196D0-90F0-11D0-9F41-00A024BB830C}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Source: SAS.EG.SDS.Model

Target Site: SASWorkspace

Stack Trace:

at SAS.EG.SDS.Model.Server.SASWorkspace()

at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op)

Earlier it was running fine suddenly I got the above error.

I have tried trouble shooting as metioned in below links:

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

12502 - The error message "Note: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead" appears when you invoke SAS® 9.1

which includes renaming the user profiles( profile2 ,profile and registry entry to old) but still no luck.

Can anyone help me with this issue ? has anyone faced the issue before.

Re: SAS EG "Cant Connect to Local Server"

Slash — Sun, 18 Aug 2013 14:18:08 GMT

Because your OS is Windows 8, the SAS 9.3 is not support it. When you install SAS 9.3, you choose the Windows 7 Compatibility mode. I tried, it can fix the problem.

Re: SAS EG "Cant Connect to Local Server"

tejjoshi — Sun, 18 Aug 2013 14:35:41 GMT

Thanks for your reply.

SAS EG 5.1 was working fine earlier with windows 8 this issue came up suddenly today, so not sure whether its really related to windows 8 compatibility issue.

Re: SAS EG "Cant Connect to Local Server"

jakarman — Sun, 18 Aug 2013 15:32:21 GMT

Did you check SAS/BASE (dms) is still working?

SAS local is some variation to access that.
When SAS-base has become corrputed you can expect errors of any kind.

A registry entry is defining the connection as the equivalent of WS-server. That is an other option to get validated (is is changed?)

The com message could be an indication of a possible other issue, Windows com functionality (is it changed?).

Re: SAS EG "Cant Connect to Local Server"

IGoddard — Wed, 21 May 2014 09:41:02 GMT

Did you get a resolution to this? We are experiencing something similar.

Thanks

Re: SAS EG "Cant Connect to Local Server"

Kurt_Bremser — Wed, 21 May 2014 12:04:06 GMT

Can't connect to local server will also happen if your setup should connect to a remote server (no local SAS installed) and the remote metadate server definition is missing.

Re: SAS EG "Cant Connect to Local Server"

abhishekpandeymails_gmail_com — Wed, 10 Jun 2015 14:15:49 GMT

I am also facing the same issue in my Office I recently installed the SAS 9.3 on windows 7 on a roaming profile with admin access but still I am facing this issue.

Re: SAS EG "Cant Connect to Local Server"

jakarman — Wed, 10 Jun 2015 16:21:49 GMT

Please give as much as possible information what you have checked and verified.

Just admin access is no solution in contrary. Having that you must be capable of doing all admin work or getting a fresh installation and start over again. When that is not your task you will lose a lot of time.

Re: SAS EG "Cant Connect to Local Server"

igforek — Tue, 21 Jun 2016 09:21:24 GMT

Hello,

I had a similar problem. I am a newbie at SAS and EG. I installed SAS 9.4 and EG 6.1 (both 64-bit) with the default options in my PC (OS win7 ultimate). When I got the problem I checked the default options in my installation DVDs and I noticed that several options were not checked by default. Among those options not checked to be installed were the "SAS® Integration Technologies". I checked it to to be installed (as well as any other unchecked option with the word "server" in it). This was a short install. This solved my problem. EG can now connect to "local" server.