topic Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server in SAS Enterprise Guide

Enterprise Guide - unable to connect to metadata server

HeatherNewton — Fri, 24 May 2024 09:54:25 GMT

Hi All, my teammates have sas newly installed in pc and got the above message when trying to use it. Any idea what could be the problem? just had sas eg installed but cannot use it, showing error message in the above attached picture. I also pinged it. What could be the problem? what other test can I do to trouble shoot? how to resolve?

urgent: please help!! unable to connect metadata server

HeatherNewton — Fri, 24 May 2024 06:26:19 GMT

Hi my colleague just have sas enterprise guide installed but couldnt connect to metadata server.

how to resolve? we tried ping and it can communicate. What could have gone wrong?

please see attached pic.

Re: urgent: please help!! unable to connect metadata server

Ksharp — Fri, 24 May 2024 06:43:26 GMT

You could add new connected string by 'Add User' button.(Make sure the configure information are all right)
And double click the new one to connect SAS server again.

Re: urgent: please help!! unable to connect metadata server

HeatherNewton — Fri, 24 May 2024 07:28:12 GMT

thanks KSharp. please could you elaborate more? where is the 'add user' button? As I am supporting my client and dont have enterprise guide interface myself I am not able to test. If it is possible, please could you solutions in great details. Thanks.

Re: urgent: please help!! unable to connect metadata server

Ksharp — Fri, 24 May 2024 07:35:03 GMT

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

Kurt_Bremser — Fri, 24 May 2024 07:36:42 GMT

Please post your questions only once, even when they're urgent.

Make sure that the SAS Metadata Server is up and running on the specified host (can other users from other computers connect to it?). Your SAS admin can assist in this.

The answer to this question will decide which steps to follow next.

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

HeatherNewton — Fri, 24 May 2024 07:55:53 GMT

yes definitely it is running fine and a lot of other people can use it

Re: urgent: please help!! unable to connect metadata server

HeatherNewton — Fri, 24 May 2024 07:56:48 GMT

thanks

after press add button, what do i need?

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

Kurt_Bremser — Fri, 24 May 2024 09:27:44 GMT

Then you need to check the connection between the afflicted computer and the metadata server.

Does the server name (always use the fully qualified domain name, in the connection profile in EG and when using ping or other OS tools) resolve to the same numerical IP address?
Are there any security tools running on the PC which might block the specific port (or even block EG completely from attempting any outside connection)?
Are there any firewalls / intelligent routers in the path which might block the connection?

My guess would be #2.

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

HeatherNewton — Fri, 24 May 2024 08:25:10 GMT

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

HeatherNewton — Fri, 24 May 2024 08:25:44 GMT

we pinged and it is communication

could this be a signal that firewall is not blocking already?

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

HeatherNewton — Fri, 24 May 2024 08:26:47 GMT

which one is #2?

Re: urgent: please help!! unable to connect metadata server

Ksharp — Fri, 24 May 2024 08:49:59 GMT

All the configure information for new connecting string. UserName ,Password,IP Address,Port Number ...... etc.

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

Kurt_Bremser — Fri, 24 May 2024 09:34:17 GMT

@HeatherNewton wrote:

we pinged and it is communication

could this be a signal that firewall is not blocking already?

ping uses a basic communication protocol (ICMP) which is (almost) never blocked by firewalls, as it poses no risk of malware transport. The fact that ping works does not mean that firewalls don't block TCP/IP communication.

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

Kurt_Bremser — Fri, 24 May 2024 09:35:08 GMT

@HeatherNewton wrote:

which one is #2?

I edited my post for more clarity.

Re: urgent: please help!! unable to connect metadata server

Patrick — Fri, 24 May 2024 09:48:07 GMT

@HeatherNewton wrote:

thanks KSharp. please could you elaborate more? where is the 'add user' button? As I am supporting my client and dont have enterprise guide interface myself I am not able to test. If it is possible, please could you solutions in great details. Thanks.

You're either the SAS Admin with all the necessary tools and permissions or you need to refer your client to the site SAS admin ....and then eventually support this admin in a screen share session if it's your client and the responsible person is only SAS admin by title (which in turn is a sign of insufficient project handover). If your client is not capable (or too small) to hire a capable SAS Admin then they are eventually a candidate for a SAS managed environment where SAS provides the SAS admin services.

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

SASKiwi — Sun, 26 May 2024 00:25:27 GMT

A couple of questions:

Are you the only user affected or are there others?
Are you using your own personal user account to connect?

If possible, try using another PC with EG, but connect with your user account - does it work or not? If it does work, then the problem is with your PC and not your user account. If it fails with your account, but works for another user's account, then the problem is with your user account.

Re: TOP URGENT! sas enterprise guide - unable to connect to metadata server

Sajid01 — Fri, 21 Jun 2024 14:16:13 GMT

Hello @HeatherNewton
The error indicates that either the user's identity has not been created in the metadata server OR he may not have been added to authentication provider(LDAP/AD etc) and proper groups assigned.
The SAS Administrator (or somebody who performs these duties) at your place should be able to assist.