topic Re: Unable to connect to metadata server - SAS VIYA in Administration and Deployment

Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Sun, 06 Apr 2025 14:20:21 GMT

I am using SAS Enterprise Guide 8.3 to connect to SAS VIYA.

When I try to make a connection I get an error Unable to connect to the metadata server, with server response: The client has connected to a SAS Workspace Server (v1.0) when it intended to connect to SAS Metadata Server. I am also appending image of the error.

The SAS Viya environment was set 5 years ago (2020), and there were no changes to the environment to our knowladge. In the past we were able to do this connection.

To our knowladge we did not have a SAS Metadata Server set up, and it was said to us at the time (in 2021) that we do not need it.

Does anyone know what the problem could be and how to fix it?

Re: Unable to connect to metadata server - SAS VIYA

SASKiwi — Sun, 06 Apr 2025 20:05:26 GMT

My understanding is that you need to define an EG connection directly with a Workspace Server, bypassing metadata profiles. What version of Viya are you using? I'm assuming it must be Viya 3 as support for Viya 4 using EG was only added recently. This is the EG Connection screen where you define a Workspace Server:

Re: Unable to connect to metadata server - SAS VIYA

andreas_lds — Mon, 07 Apr 2025 06:03:51 GMT

As far as is know, you need - at least - EG 8.4 to connect it to viya.

Re: Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Mon, 07 Apr 2025 06:59:32 GMT

Yes we are using SAS VIYA 3.4. Build date is in the year 2020.

We already have a Default server for the active profile added, but Additional SAS Workspace Servers are empty.

I will try and add a new one.

Re: Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Mon, 07 Apr 2025 09:47:58 GMT

Adding another Server did not fix my issue

Re: Unable to connect to metadata server - SAS VIYA

Patrick — Mon, 07 Apr 2025 11:52:05 GMT

From what I know SAS Studio was initially the only client for Viya - but that has changed not the least due to customer demand.

I believe the earliest versions for an EG to Viya connection is EG8.2 with Viya 3.5 . @SASKiwi provided the links for these versions in this discussion.

There have been a lot of improvements since Viya 3.4 and I'd really recommend to upgrade. This would also make the EG to Viya connection easier. Using SAS Enterprise Guide with SAS Viya 4

Re: Unable to connect to metadata server - SAS VIYA

SASKiwi — Mon, 07 Apr 2025 21:47:48 GMT

What error(s) are you seeing now? It's possible you might need a firewall rule change to gain access to your Workspace Server. Tech Support is your best option to troubleshhot further.

Re: Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Tue, 08 Apr 2025 04:42:47 GMT

The error remains the same.
There are no firewalls between our Windows server and the SAS Viya Linux server we are trying to access.
We also successfully established an SSH connection from Windows to Linux, so this should not be the issue.

Re: Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Tue, 08 Apr 2025 08:21:31 GMT

I was just checking SAS Enterprise Guide releases.

SES Enterprise Guide 8.3 supports SAS Viya 3.4 which we are using. So based on this versions of the software should not be an issue.

Re: Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Tue, 08 Apr 2025 09:30:09 GMT

With adding new server I was able to open a server in SAS Enterprise guide (in the bottom left on the image), and I can access tables that are loaded to that server.

However I am unsure that I can now work with SAS Viya code, since my profile is still connected to the old SAS 9 profile (in the image in the top left).

How do I know in which environment I am now (SAS Viya or SAS 9)?

Are there additional steps I have to take to connect to SAS Viya?

Re: Unable to connect to metadata server - SAS VIYA

Patrick — Tue, 08 Apr 2025 10:20:55 GMT

You could just run Proc Setinit. The result in the log will tell you if you run under a SAS9.4 or Viya workspace server.

proc setinit;
run;

Re: Unable to connect to metadata server - SAS VIYA

KlemenVrhovec — Thu, 10 Apr 2025 05:29:10 GMT

Thank you everyone for your help. I managed to connect to SAS Viya from the server connections by selecting the new server as the default server.

I opened the server in the EG Dashboard (bottom left), and it prompted me for the password.

After that, I checked the environment with

proc setinit;
run;

and saw that I have the SAS Viya environment running in EG.