topic ERROR: CLI error trying to establish connection in preassigned Library in Administration and Deployment

ERROR: CLI error trying to establish connection in preassigned Library

MG18 — Tue, 05 Jul 2022 10:22:44 GMT

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.

Re: ERROR: CLI error trying to establish connection in preassigned Library

gwootton — Tue, 05 Jul 2022 14:36:51 GMT

Does the log on the SQL server have any information on the rejection? You may wish to engage technical support as it may require reviewing debug logs.

Re: ERROR: CLI error trying to establish connection in preassigned Library

Sajid01 — Wed, 06 Jul 2022 19:39:41 GMT

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.