The Register Tables wizard in SAS Management Console might fail to register CAS tables and return "ERROR: Connection failed...Access denied..."


After configuring a connection to a Viya Cloud Analytic Services server with an authentication domain and an associated CAS library in SAS Management Console, registering the table might fail with the following error:

ERROR: Connection failed. Server returned: SAS Logon Manager authentication failed: Access denied.
ERROR: Unable to connect to Cloud Analytic Services <cas host> on port <cas port>. Verify connection parameters and retry.
ERROR: Error in the LIBNAME statement.

To work around the issue, you can submit the METALIB procedure code manually in SAS after establishing a connection to CAS and assigning the library:

CAS CASAUTO HOST="<cas-host>" PORT=<cas-port> AUTHDOMAIN="<cas-authdomain>";
LIBNAME <libname> META LIBRARY="<meta-library-name>";
PROC METALIB;
   omr (library="<meta-library-name>");
   update_rule=(delete);
   report(matching);
RUN;
CAS CASAUTO TERMINATE;

You can also modify the PROC METALIB options to change its behavior as described in the METALIB Procedure section of SAS® 9.4 Language Interfaces to Metadata, Third Edition.