topic Re: How to connect SQL server Database using SAS University Edition in SAS Studio

How to connect SQL server Database using SAS University Edition

charlo77 — Tue, 04 Sep 2018 02:51:38 GMT

Hello guys,

I am new to SAS. I am trying to connect SAS university edition to SQL SERVER using windows authentication mode. Both are installed in my local machine. I followed the instructions listed here

https://communities.sas.com/t5/SAS-Analytics-U/Connect-to-SQL-Server-Oracle-Database-by-SAS-Universi...

but keep having the error below. Please can you help?

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver

specified

ERROR: Error in the LIBNAME statement.

Re: How to connect SQL server Database using SAS University Edition

Reeza — Tue, 04 Sep 2018 03:18:15 GMT

SAS UE is not designed to connect to a server. I don't believe that's an acceptable use either.

I'm assuming by SAS UE you're referring to a version you downloaded from this website or AWS, not a version provided by your University.

If you're affiliated with a University you can get a full version either free of charge or for a small nominal cost.

@charlo77 wrote:

Hello guys,

I am new to SAS. I am trying to connect SAS university edition to SQL SERVER using windows authentication mode. Both are installed in my local machine. I followed the instructions listed here

https://communities.sas.com/t5/SAS-Analytics-U/Connect-to-SQL-Server-Oracle-Database-by-SAS-Universi...

but keep having the error below. Please can you help?

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver

specified

ERROR: Error in the LIBNAME statement.

Re: How to connect SQL server Database using SAS University Edition

SASKiwi — Tue, 04 Sep 2018 03:23:17 GMT

Please post your LIBNAME statement.

Re: How to connect SQL server Database using SAS University Edition

charlo77 — Tue, 04 Sep 2018 03:58:02 GMT

LIBNAME z PCFILES SERVER='192.168.56.1' DSN=AdventureWorks2012 USER=XXXX
PASSWORD=xxx SCHEMA=dbo readbuff=10000 access=readonly;

Re: How to connect SQL server Database using SAS University Edition

SASKiwi — Tue, 04 Sep 2018 04:07:04 GMT

Check in the ODBC Administrator that you have an SQL Server ODBC driver installed and you have used that to create a Data Source Name called AdventureWorks2012.

I am pretty sure you would have to run the SAS PC File Server on the same PC from where you are running SAS UE and also configuring the data source in the ODBC Administrator.

Re: How to connect SQL server Database using SAS University Edition

Cynthia_sas — Tue, 04 Sep 2018 14:19:44 GMT

Hi:
I believe that PC File Server has to be installed inside the University Edition Virtual Machine, where sas.exe is located. Since the Virtual Machine is locked down, you can't install PC File Server on the Virtual Machine.

We don't expect that students will need to use PC File Server for learning purposes.

Cynthia