Hello Everyone, I am trying to configure an ODBC to SQL Server on my current SAS Server, but I have been met with an error as seen below . This is the first time I am trying to configure an ODBC to SQL Server and I have scoured the internet for a solution to this error, with a lot of different solutions relating to the following, 1. Enabling TCP/IP stack for SQL server. 2. Checking windows firewall settings and ports. 3. Checking the connectivity of current SAS Server to SQL Server etc. I can't seem to understand what could be the issue, however I have been trying to connect to a SQL Server from a machine that does not have SQL Server management Studio or any other SQL application installed on it (It does however have an ODBC SQL driver on it). Do I need the SQL client setup on my SAS Server before creating an ODBC to SQL ?
... View more