Hi All,
I am able to run below libname
LIBNAME PDSPRD ODBC DEFER=YES DATAsrc=PXX_XXD SCHEMA=PXXH USER=datxxxxxds PASSWORD="XXXXXXXXXX";
I have to make this as preassigned library and for I have added authdomain in existing connection and edited the library property as checked preassign option . added the datxxxxxds userid and password to respective group.
But when I am running code it is giving error:-
proc datasets library=pdsprd memtype=data;
run;
Error:- ERROR: CLI error trying to establish connection: [unixODBC][Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot open
database "PXX_XXD" requested by the login. The login failed. : [unixODBC][Microsoft][ODBC Driver 13 for SQL Server][SQL
Server]Login failed for user 'datxxxxxds'.
Can Someone help me on this.