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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 5131 views
  • 0 likes
  • 3 in conversation