BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Yarlanil59
Obsidian | Level 7

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 ------------------------------
1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

2 REPLIES 2
SASKiwi
PROC Star

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. 

Kurt_Bremser
Super User

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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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