topic ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436093#M12228 <P>Hi i am seeing the below error intermittently. not sure what the issue is.&nbsp;</P><P>&nbsp;</P><P>Any help on this is much appreciated.&nbsp;</P><P>&nbsp;</P><P>ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired</P><P>ERROR: Error in the LIBNAME statement.</P><P>&nbsp;</P><P>Thank you.</P> Sun, 11 Feb 2018 17:47:08 GMT ravi15 2018-02-11T17:47:08Z ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436093#M12228 <P>Hi i am seeing the below error intermittently. not sure what the issue is.&nbsp;</P><P>&nbsp;</P><P>Any help on this is much appreciated.&nbsp;</P><P>&nbsp;</P><P>ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired</P><P>ERROR: Error in the LIBNAME statement.</P><P>&nbsp;</P><P>Thank you.</P> Sun, 11 Feb 2018 17:47:08 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436093#M12228 ravi15 2018-02-11T17:47:08Z Re: ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout exp https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436095#M12229 <P>one of the answers on SAS communities and other important links giving some info about this</P> <P>&nbsp;</P> <P><A href="https://communities.sas.com/t5/Administration-and-Deployment/CLI-error-connecting-to-SQL-Server/m-p/410188#M11046" target="_blank">https://communities.sas.com/t5/Administration-and-Deployment/CLI-error-connecting-to-SQL-Server/m-p/410188#M11046</A></P> <P><A href="http://support.sas.com/kb/19/707.html" target="_blank">http://support.sas.com/kb/19/707.html</A></P> <P><A href="http://support.sas.com/kb/14/386.html" target="_blank">http://support.sas.com/kb/14/386.html</A></P> Sun, 11 Feb 2018 17:57:20 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436095#M12229 kiranv_ 2018-02-11T17:57:20Z Re: ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout exp https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436873#M12265 <P>Some important notes:</P><P>&nbsp;</P><P>1. Do you have SAS/Access engine for ODBC?</P><P>2. Have you installed the ODBC driver on the Compute Tier?</P><P>3. If yes, did you edited the odbc.ini file and include the DataSrc information?</P><P>4. If above setting are completed, confirm if the service account used to connect to the Database has the required permission to access.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 13 Feb 2018 21:07:32 GMT https://communities.sas.com/t5/Administration-and-Deployment/ERROR-CLI-error-trying-to-establish-connection-SAS-ODBC-SQL/m-p/436873#M12265 SangramjitPanda 2018-02-13T21:07:32Z