ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired

[ravi15]

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.

Thank you.

[kiranv_]

one of the answers on SAS communities and other important links giving some info about this

https://communities.sas.com/t5/Administration-and-Deployment/CLI-error-connecting-to-SQL-Server/m-p/...

http://support.sas.com/kb/19/707.html

http://support.sas.com/kb/14/386.html

[SangramjitPanda]

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.