BookmarkSubscribeRSS Feed
MG18
Lapis Lazuli | Level 10

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.

2 REPLIES 2
gwootton
SAS Super FREQ
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.
--
Greg Wootton | Principal Systems Technical Support Engineer
Sajid01
Meteorite | Level 14

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

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.

Discussion stats
  • 2 replies
  • 4425 views
  • 0 likes
  • 3 in conversation