Desktop productivity for business analysts and programmers

SAS Enterprise guide is not connecting to Metadata server

Accepted Solution Solved
Reply
Contributor
Posts: 31
Accepted Solution

SAS Enterprise guide is not connecting to Metadata server

When user is trying to connect to SAS Enterprise guide 4.3. It is showing the following error.

 

A connection could not be made to the SAS Metadata Server but is required for the current operation. Please see your administrator.
 
--------------------------------------------------------
 
Connection failed
 
------------------------------ Technical Information Follows ------------------------------
 
SAS.EG.SDS.Metadata.MetadataException: Connection failed ---> System.Runtime.InteropServices.COMException (0x80042AFC): The machine name could not be resolved to an IP address.
   at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String Name, Boolean synchronous, ServerDef pIServerDef, String LoginName, String Password)
   at SAS.EG.SDS.Metadata.OMSProvider.Connect()
   --- End of inner exception stack trace ---
   at SAS.EG.SDS.Metadata.OMSProvider.Connect()
   at SAS.EG.SDS.Metadata.MetadataManagerV2.SAS.EG.SDS.Metadata.IMetadataConfiguration.set_ActiveProvider(Provider value)
   at SAS.EG.SDS.Dialogs.ProviderConnectDlg.Connect(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
 
------------------------------ End of Technical Information ------------------------------

Accepted Solutions
Solution
‎08-30-2016 06:46 AM
Esteemed Advisor
Posts: 6,646

Re: SAS Enterprise guide is not connecting to Metadata server

This:

The machine name could not be resolved to an IP address

reveals the cause of your problem. The Domain Name System resolver could not find an entry that matches your host name entered in the connection profile. Any connection by name uses the DNS to retrieve the numerical Internet Protocol address.

Verify the name with your IT people / SAS adminstrator.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Respected Advisor
Posts: 3,063

Re: SAS Enterprise guide is not connecting to Metadata server

It looks like EG cannot find the metadata server name you have stored in your active EG connection profile. You could try to PING the server name to see it is contactable. From a Windows command line enter: ping metadataservername.

 

You should also contact your SAS server admin to troubleshoot this problem as it could be caused by a variety of issues. 

Solution
‎08-30-2016 06:46 AM
Esteemed Advisor
Posts: 6,646

Re: SAS Enterprise guide is not connecting to Metadata server

This:

The machine name could not be resolved to an IP address

reveals the cause of your problem. The Domain Name System resolver could not find an entry that matches your host name entered in the connection profile. Any connection by name uses the DNS to retrieve the numerical Internet Protocol address.

Verify the name with your IT people / SAS adminstrator.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 983 views
  • 0 likes
  • 3 in conversation