Usage Note 48348: Using NTLM authentication with SAS/ACCESS® Interface to Microsoft SQL Server
 |  |  |  |  |
Support is now available for NTLM authentication to Microsoft SQL Server through SAS/ACCESS Interface to Microsoft SQL Server. To enable this feature, the release of the DataDirect SQL Wire Protocol 7.0.1 driver must be downloaded from the SAS website.
Use the following odbc.ini entry to initiate NTLM authentication:AuthenticationMethod=9
Your LIBNAME statement requires a Windows user ID and password:
libname myconn sqlsvr dsn=MySQLDSN user="Domain\userid" password="WindowsPassword" schema=MySchema;
To access the latest driver, click the Downloads tab in this note.
Important: If you plan to use Kerberos as your SQL Server authentication mechanism, then you need to follow the instructions in this SAS Note 42605
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | Linux for x64 | 9.3_M2 | 9.3 TS1M2 | ||
| HP-UX IPF | 9.3_M2 | 9.3 TS1M2 | ||||
| 64-bit Enabled Solaris | 9.3_M2 | 9.3 TS1M2 | ||||
| 64-bit Enabled AIX | 9.3_M2 | 9.3 TS1M2 | ||||
| Solaris for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
You can download DataDirect's ODBC SQL Server driver from the following page:
ftp.sas.com/techsup/download/hotfix/datadirect_sqlserver.html
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS SQL Server |
| Date Modified: | 2012-11-28 11:29:37 |
| Date Created: | 2012-10-31 15:55:27 |