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!
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.
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!
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.
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:
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.