Desktop productivity for business analysts and programmers

LOCAL server could not be connected

Reply
Frequent Contributor
Posts: 77

LOCAL server could not be connected

Hi,

 

I am trying to schedule my programs using SAS MANAGEMENT CONSOL, for that I need to set up the connection (LOCAL atleat as there is no server). When tried I get the below message: Please advise:

 

Connection failed
Could not establish a connection to the SAS server on the requested machine. Verify that the SAS server has been started with the -objectserver option or that the SAS spawner has been started. Verify that the port Combridge is attempting to connect to is the same as the port SAS (or the spawner) is listening on.


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

Exception Details:
----------------------------------------
Exception type: SAS.EC.Directory.Metadata.MetadataException
Message: Connection failed
Source: EC.Directory
Target Site: MakeConnection
Data:
m_HostName : localhost
m_Port : 8561
m_Userid : Sindu


Stack Trace:
at SAS.EC.Directory.Metadata.OMSProvider.MakeConnection()
at SAS.EC.Directory.Metadata.OMSProvider.Connect()
at SAS.EG.SDS.Dialogs.ProviderConnectDlg.Connect(Object sender, DoWorkEventArgs e)

Inner Exception Details:
----------------------------------------
Exception type: System.Runtime.InteropServices.COMException
Message: Could not establish a connection to the SAS server on the requested machine. Verify that the SAS server has been started with the -objectserver option or that the SAS spawner has been started. Verify that the port Combridge is attempting to connect to is the same as the port SAS (or the spawner) is listening on.
Source: SASObjectManager
Target Site: CreateObjectByServer

Stack Trace:
at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String Name, Boolean synchronous, ServerDef pIServerDef, String LoginName, String Password)
at SAS.EC.Directory.Metadata.OMSProvider.MakeConnection()

Super User
Posts: 9,867

Re: LOCAL server could not be connected

Do you have a metadata server licensed at all? It needs to be configured and started.

(I guess you need Integration Technologies licensed for the metadata server to work)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Frequent Contributor
Posts: 77

Re: LOCAL server could not be connected

Posted in reply to KurtBremser
@KurtBremser sorry if my query sounds stupid but, how do I find out if I am licensed for that?

Thanks
Super User
Posts: 9,867

Re: LOCAL server could not be connected

To see your licenses, run proc setinit.

Who set up the SAS system? That person could easily tell you if (s)he needed to configure the metadata server.

And you should be able to identify a running metadata server by its starting script, which would be called from SASCONF/Lev1/SASMeta/MetadataServer.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 3 replies
  • 72 views
  • 0 likes
  • 2 in conversation