Hi, no it was done by a user w' sas administrators group membership.
We checked the TLS setting on the compute server, it was at 1.2, target DB is sql server 2016, so we downloaded the MS SQ Sever driver (17) that supports. The connection was successful.
Like to jump off the first floor.
Hi, no it was done by a user w' sas administrators group membership.
Hope they don't have the unrestricted permission.
Try registering the tables with sasdemo account.
After some further investigation turned out there was schema error, relevant schema was not chosen for the library. Once we obtained the schema listing of all tables in a DB and identified what was relevant, we were okay.
TY all for your kind help.
S
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.