topic Re: SAS Connection to SQL server using Windows authentication in Administration and Deployment

SAS Connection to SQL server using Windows authentication

helannivas88 — Mon, 30 Jul 2018 15:00:56 GMT

Hi ,

We have a requirement to connect to the SQL server using Windows Authentication . Till now we have connected to the same server using odbc connectivity and a database user has been created specifically for our project and the same has been defined in SAS Authdomain and we are able to connect to the database.

As I said, now we have to connect using WIndows authentication mode. SQL Server and SAS Server are in the same domain and my ID has been added to the domain and the privilege's for my ID has been provided in the SQL server. I have configured the odbc.ini file as 'trusted connection = yes' . But still I'm not able to connect to the SQL server.

Is there any other option I have to use in odbc.ini file to connect for Windows authentication?? Thanks in Advance.

Re: SAS Connection to SQL server using Windows authentication

SASKiwi — Mon, 30 Jul 2018 21:53:47 GMT

Please post your SAS log containing the complete test database connection program and any error messages.

Re: SAS Connection to SQL server using Windows authentication

PaulHomes — Tue, 31 Jul 2018 02:24:38 GMT

Depending on your SAS architecture you may need to get your domain admins to configure the SAS Computer Tier machine(s) as Trusted for Delegation - see SAS and IWA: Two Hops

Re: SAS Connection to SQL server using Windows authentication

helannivas88 — Thu, 23 Aug 2018 10:07:13 GMT

Hi,

We do have IWA configured in our platform and after editing the odbc.ini file with the below details I can able to connect to the SQL server using Windows Authentication

Authentication Mode = 9 & Domain = <Domain Name>

While creating a library in SMC I have used Default authentication , so the libname automatically used my username and pwd for connection. Successfully I can able to do it.

But now the problem is if I want to use the libame statement in SAS DI or if it want to use the passthrough facility , I cant able to use AuthDomain as 'DefaultAuth'.

What is the libname statement should be used with the odbc is defined as Windows Authentication?? thanks in adavance.