BookmarkSubscribeRSS Feed
mrtball
Obsidian | Level 7

Hello All,

Our SQL Server DBA's have identified a number of unexpected and failed connections which we have tracked down to our use of Pre-Assigned libraries - the main way to solve this seems to be for us to use the Defer=Yes option in libnames or the 'Whether to defer a connection until needed'  to Yes in library settings in SAS management console.

DEFER=LIBNAME option SAS note is here: SAS/ACCESS(R) 9.2 for Relational Databases: Reference, Fourth Edition

The question we have about this is are there any reasons why we shouldn't use this as default? (testing has show that this will remove un-needed SQL Server connections and any failed connections due to users not having permissions for certain databases)

This is the option in question in SAS MC (which we've set to Yes in our test environment)...

Libname Connection Options.jpg

Thanks for any responses in advance,

Tom

3 REPLIES 3
jakarman
Barite | Level 11

As you are also needing authentication the option of "defer=yes" is very profitable by avoiding failed attempts. It will only open up the library and do the authentication (login) when the data is needed.

For minimizing connections use the option for that eg Oracle SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Sixth Edition

The benefit is the options of using temporary tables.

Why these are not the default settings. Probably SAS build the interface in the days one connection with a shared group account was the standard way of doing it.
Not acceptable these days but a change of default is hard to get accepted.

---->-- ja karman --<-----
SASKiwi
PROC Star

We have made DEFER = YES our default set up for SQL Server libraries and we haven't had any problems or issues with that. If should speed up connecting to your SAS server as well via EG etc.

mrtball
Obsidian | Level 7

Thank you both for you responses - based on our testing and your responses.

We are going to deploy the use of defer=yes to our production environment.

Many Thanks,

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 3028 views
  • 10 likes
  • 3 in conversation