Looking for information on how to setup in a Linux Base SAS deployment using version 9.4 m7 , where we currently can pass Windows Active Directory sign on information into SAS but want to be able to then pass that AD information to databases in SQL Server. In talking with SAS they said they recommended using Kerberos. We are looking for information on how to setup the pass through of info to Linux so that users would only need to supply their sign on information once and the sign on information wouldn't need to be in a lib ref statement, etc. it would be passed automatically. How would we set this up in SAS to pass the info. If anyone also knows the Kerberos settings that would be needed, that would be helpful as we are not sure how to set that up. We have setup Kerberos thru our Linux admin and currently when we try to pass the information we are getting the following error: ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Wire Protocol driver]Security Services Error: Unspecified error at the GSS layer. There may be other messages with more info. : [SAS][ODBC SQL Server Wire Protocol driver]Security Services Error: Server not found in Kerberos database. ERROR: Error in the LIBNAME statement. The libname statement is setup as follows: LIBNAME tempwork odbc dsn=temp_work SCHEMA=XXXXXX; Please let me know if you need further information Thanks
... View more