topic Unable to connect to SQL Server in Administration and Deployment

Unable to connect to SQL Server

Ram7 — Fri, 09 Jun 2023 05:21:49 GMT

Hi Team,

client is not able to run the code in SAS EG and please could help below issue.

proc sql;
2487       connect to ODBC as con1
2488       (READBUFF=5000 INSERTBUFF=5000 UTILCONN_TRANSIENT=YES DEFER=YES CONNECTION=GLOBAL CURSOR_TYPE=FORWARD_ONLY
2489       DATAsrc=AGL_NDM_PRD1_DS_NDMFEED authdomain=AGL_NDM_PRD1_DS_RW);
NOTE: Credential obtained from SAS metadata server.
2490       execute (delete from DBO.DS_SCORE_CARES_COLL where ScoreDate<getdate()-30)
2491       by con1;
ERROR: CLI error trying to establish connection: [unixODBC][Easysoft][SQL Server Driver][SQL Server]Communication link failure:
       read failed : [unixODBC][Easysoft][SQL Server Driver][SQL Server]Client unable to establish connection: socket read failed

Thanks & Regards,

Rama

Re: Unable to connect to SQL Server

Kurt_Bremser — Fri, 09 Jun 2023 05:22:22 GMT

Your SQL Server client is not able to connect to the database; this needs to be solved outside SAS first. Get help from your database administrators.

Re: Unable to connect to SQL Server

Kurt_Bremser — Fri, 09 Jun 2023 05:25:54 GMT

PS since you are obviously able to connect to a SAS workspace server and run code (otherwise you wouldn't get a log), I changed your subject line and moved this to Administration and Deployment.

You have no issue logging in with Enterprise Guide.