02-11-2018 12:47 PM
Hi i am seeing the below error intermittently. not sure what the issue is.
Any help on this is much appreciated.
ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired
ERROR: Error in the LIBNAME statement.
02-11-2018 12:49 PM - edited 02-11-2018 12:57 PM
one of the answers on SAS communities and other important links giving some info about this
02-13-2018 04:07 PM
Some important notes:
1. Do you have SAS/Access engine for ODBC?
2. Have you installed the ODBC driver on the Compute Tier?
3. If yes, did you edited the odbc.ini file and include the DataSrc information?
4. If above setting are completed, confirm if the service account used to connect to the Database has the required permission to access.