cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nilshermann_wiggen_knowit_se
‎07-03-2020
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Using AD-user for database connection in batch triggered by LSF.

by Fluorite | Level 6 in Administration and Deployment
‎07-02-2020 07:14 AM
‎07-02-2020 07:14 AM
Hi! I have tried to define the libname in both the metadata and in an user written code that runs a database procedure. I get the same error:   88 /* Access the data for A.19 analytix_tos_test */ 89 LIBNAME anltxtos ODBC DATAsrc=analytix_tos_test SCHEMA=dbo AUTHDOMAIN="analytix_access" ; NOTE: Credential obtained from SAS metadata server. ERROR: CLI error trying to establish connection: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '**\lsfadm'.   I get the same error if I choose the correct "Default Login" in the libname. Still the lsfadm is being used. ... View more

Re: Using AD-user for database connection in batch triggered by LSF.

by Fluorite | Level 6 in Administration and Deployment
‎06-29-2020 04:33 AM
‎06-29-2020 04:33 AM
Hi! Thank you for the reply! We design the flow in Management Console with our own user. We get prompted when scheduling the flow, like you do, but then we enter "<domain>\lsfadm" and password. Your solution sounds easy and simple in a way, but we rather won't have the flows run by multiple usernames. Doesn't that get a bit messy in LSF? With this solution all administration users that is scheduling flows need access to the source databases also right? We rather want one AD user pr source database for this. In that way we are not dependent on one spesific administrator to administer the flow. This works fine where we have local database users, but, as the problem is, not when using AD user. Thanks again for you reply! ... View more

Re: Using AD-user for database connection in batch triggered by LSF.

by Fluorite | Level 6 in Administration and Deployment
‎06-29-2020 04:16 AM
‎06-29-2020 04:16 AM
Hi! Thank for your response 🙂 Yes, I can logon to the database outside sas. I also created and tested (successfully) an ODBC connection in OS where sas is running. Thanks again! ... View more

Using AD-user for database connection in batch triggered by LSF.

by Fluorite | Level 6 in Administration and Deployment
‎06-26-2020 09:05 AM
1 Like
‎06-26-2020 09:05 AM
1 Like
Hi!   We are using LSF for batch scheduling, with the lsfadm user. When running jobs that connects to databases (MSsql, Oracle) we want to use Active Directory users for access to the databases. What we have done till now: Created local database users and registered these in SAS metadata. We have made authentication domains for each user login (to source databases). We made a metadata user group with the database user account with the correct authentication domain Then we have placed the lsfadm user in this goup. This works, but when we want to use AD-users for accessing databases we can’t get it to work. When trying to use AD users instead of local database users the batch is not using the database user, but instead uses the lsfadm user in the connection string/libname. We then get errors in the libname statement. We have also tried to put the AD-users account directly on the lsfadm user, but no luck. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-03-2020 06:22 AM
Likes from
View All
Quick links