topic Re: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed in Administration and Deployment

Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed

manial — Fri, 07 Sep 2018 02:15:33 GMT

We have stored process where we are loading data from our compute server to the server where SAS VA is installed.

But only the admin user is able to load the data to using the STP, other users are getting error like

/*---- Implicit Transfer of Data ----*/
options comamid=TCP;
%let local = ap-xxxx.xxxx.xxxx 7551;

122 data _null_;
123 signon local AuthDomain="DefaultAuth" noscript;

ERROR: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed.
ERROR: Remote signon canceled.
124 run;

Could you please help us to resolve the issue. So other users also able to load the data using STP.

Best Regards,

Manas

Re: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed

SASKiwi — Fri, 07 Sep 2018 03:45:09 GMT

If I'm understanding your setup correctly, stored processes run under a service account often called SASSRV but can be site-customised. If that account is not also an OS on your SAS VA server and defined in VA metadata as a user account associated with DefaultAuth then the SIGNON to VA will fail.

Re: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed

manial — Fri, 07 Sep 2018 03:52:10 GMT

The user is having access to SAS VA and also are part of host server groups for SAS services.

Only one user is that is admin user able perform the task is having admin and unrestricted access and its a host account.

Other users are AD domain users and have sufficient access to SAS services and SAS VA.

data _null_;
27 signon local AuthDomain="DefaultAuth" noscript;

ERROR: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed.
ERROR: Remote signon canceled.
28 run;

Re: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed

manial — Tue, 11 Sep 2018 06:38:03 GMT

Hi,

We have resolved the issue

by creating directly passing authentical user id and password instead of Authdomain.

options comamid=TCP;
%let local = ap-121212.212323.XXXX 7551;

data _null_;
signon local user="&UserID" password="&PWD_password" noscript;
run;

Re: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed

SASKiwi — Tue, 11 Sep 2018 20:55:03 GMT

@manial - the SIGNON statement doesn't have to be inside a DATA _NULL_ step. You can just use it by itself in open code.

Also if your SAS / VA servers run on Windows you can use SSPI to avoid providing a userid and password as well:

https://documentation.sas.com/?docsetId=connref&docsetTarget=n08jdy6qt2ox28n1x7v62udvd6in.htm&docsetVersion=9.4&locale=en