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()
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)
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.