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'.
From your post it appears that you are able to connect through the libname statement. The errors shows the login failed for the user xyz. Have a look at the (1)username and password you have used in the group and (2) whether the user for whom the error has been reported is a member of the group.