Architecting, installing and maintaining your SAS environment

Connect SAS server to SQL server with ODBC

Accepted Solution Solved
Reply
Regular Contributor
Posts: 168
Accepted Solution

Connect SAS server to SQL server with ODBC

Hi All,

 

   We are using SAS in unix enviroments, in order to access SQL server data with ODBC, the  SQL server name, port#,databasename, user and password etc needs to define in the ODBC.ini file in the unix enviroments.

   My question is: Is the user authentication has to be SQL Server authentication? or Can the user use withdowns NT authentication with network login ID? Thank you!

 

Jade


Accepted Solutions
Solution
‎01-20-2017 08:40 AM
Trusted Advisor
Posts: 1,312

Re: Connect SAS server to SQL server with ODBC

Hello,

 

here you are speaking about Kerberos handshakes and SPNs. If you do have those set, you include your unix server in your active directory and you set delegation properly, it should be possible.

View solution in original post


All Replies
Regular Contributor
Posts: 168

questions of Connect SAS server to SQL server with ODBC

Hi All,

 

   We are using SAS in unix enviroments, in order to access SQL server data with ODBC, the  SQL server name, port#,databasename, user and password etc needs to define in the ODBC.ini file in the unix enviroments.

   My question is: Is the user authentication has to be SQL Server authentication? or Can the user use withdowns NT authentication with network login ID? Thank you!

 

Jade

Solution
‎01-20-2017 08:40 AM
Trusted Advisor
Posts: 1,312

Re: Connect SAS server to SQL server with ODBC

Hello,

 

here you are speaking about Kerberos handshakes and SPNs. If you do have those set, you include your unix server in your active directory and you set delegation properly, it should be possible.

Regular Contributor
Posts: 168

Re: Connect SAS server to SQL server with ODBC

Posted in reply to JuanS_OCS

Thank you! can you let me know more details or any reference links for me to read? Really a newbie hereSmiley Happy

Trusted Advisor
Posts: 1,312

Re: Connect SAS server to SQL server with ODBC

[ Edited ]

While I am not an expert on that area, I am just aware of the architecture/design impact, you can do the same as I do: ask Google. Something as the following: https://www.google.nl/search?q=unix+odbc+kerberos&oq=unix+odbc+kerberos&aqs=chrome..69i57.9552j0j7&s...

 

It gives me some interesting technical details:

 

https://msdn.microsoft.com/en-us/library/hh568450(v=sql.110).aspx

http://www.easysoft.com/products/data_access/odbc-sql-server-driver/kerberos.html

http://help.interfaceware.com/kb/904

And so on.

 

As mentioned, this has very little or nothing to do with SAS. best is to ask your Unix and DBAs, they should know what to do.

 

Just to be sure: Once the ODBC driver can work KRB with your SQL Database, on SAS you will need to set IWA with Kerberos Authentication, on your SAS Workspace Server:

https://support.sas.com/documentation/cdl/en/bisecag/69827/HTML/default/n1d1zo1jsf2o0en1ehu4c4simfky...

http://support.sas.com/resources/papers/proceedings13/476-2013.pdf (A simply awsome paper from @StuartRogers )

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 659 views
  • 2 likes
  • 2 in conversation