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

[manial]

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

[SASKiwi]

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.  

[manial]

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;

[manial · Accepted solution]

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;

[SASKiwi]

@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&docset...