05-11-2018 10:16 AM
I have a requirement to connect to SQL Server database from SAS. So Before editing the odbc.ini, I have checked whether the SQL server database and port are opened from SAS servr.
cat < /dev/tcp/<Server_name>/<Port_no>.
And I haven't got connection refused output. So the database and port are opened in SQL server database and I think I can able to establish the connection.
Then I have edited the odbc.ini file and created a DSN. And created a SQL Server library in SAS SMC.
But while accessing the database , I have got a error that Connection refused ,verify hostname and port number .
Can anybody help me on this. Thanks in advance.
05-11-2018 04:48 PM