topic Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box in SAS Enterprise Guide

Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Babloo — Tue, 02 Jun 2015 13:34:52 GMT

When I tried to connect SAS EG, I got error as attached whereas I could work on base SAS without any issues. SAS version is 9.3. AIX box is 64 bit.

Kindly shed some lights on this.

Thanks.

Note: I removed confidential information from the attachment.

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

SASKiwi — Tue, 02 Jun 2015 19:46:00 GMT

So have you "verified the following" as listed in your message?

Also please explain what you mean by "work on base SAS without any issues". Which base SAS are you refering to? One installed on your virtual PC or on your AIX server?

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

twocanbazza — Wed, 03 Jun 2015 03:25:15 GMT

Have you got a SAS profile defined or a SAS metadata server running?

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Babloo — Wed, 03 Jun 2015 06:13:55 GMT

Although I got a SAS profile, EG throws me the attached error as per my initial post before I supply my credentials.

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Babloo — Wed, 03 Jun 2015 06:15:58 GMT

Yes, I "verified the points" from the error message.

Base SAS is installed in AIX server.

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Kurt_Bremser — Wed, 03 Jun 2015 07:41:23 GMT

It seems to be all there:

"The password specified for user ... has expired and needs to be changed"

Change your password on the server, using ssh or another terminal connection.

BTW, nice to know that SAS now provides a more detailed message. In 9.2, all one gets is a failed connection.

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Babloo — Wed, 03 Jun 2015 08:19:06 GMT

Password is set in such a way that it will never expire.

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Kurt_Bremser — Wed, 03 Jun 2015 08:57:59 GMT

Have you tried to log on to the AIX server with ssh or telnet?

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Babloo — Wed, 03 Jun 2015 12:51:43 GMT

I could login to AIX server with telnet

Re: Unable to connect SAS EG 7.1 on virtual PC to metadata server on AIX box

Kurt_Bremser — Wed, 03 Jun 2015 17:04:18 GMT

Then the next tests I would make:

- verify that the username in the metadata profile is actually yours. Since EG automatically tries the last one used, the problem may be there.

- check that there are no issues with the UserID that don't manifest themselves readily. Inspect /etc/security/passwd and /etc/security/lastlog (needs root), if the server authentication is done the standard AIX way. Otherwise, check LDAP or whatever authentication provider is used.

- restart the metadata server..Sometimes it "remembers" that a userid was locked and needs to be refreshed the hard way.