Connect to MS SQL Server through SAS

[Sajid01]

1.The error " ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified " clearly shows that your SAS server is not able to connect to SQL Server.

2.The question is posted in the EG board so I am presume you are running SAS EG on the desktop.
3.Where is SAS running - on your desktop or the server? and what is the operating system on the server?

4.Where is SQL server installed?

[SASKiwi]

@Sajid01  - From what I understand @tampham92 is using a remote SAS server from EG and hasn't yet confirmed what operating system it is running on. I've already pointed out that only a SAS administrator can configure remote data sources and in any case may also be able to provide the correct connection details.