Unable to connect to SQL Server

[Ram7]

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

[Kurt_Bremser]

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.

[Kurt_Bremser · Accepted solution]

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.