CLI errors occur when you use SAS/ACCESS® Interface to Microsoft SQL Server with NTLM authentication


When connecting with SAS/ACCESS Interface to Microsoft SQL Server with NTLM authentication, one of the following errors can occur:

ERROR: CLI error trying to establish connection: [SAS][ODBC 20101 driver]1251

Error: CLI error trying to establish connection: [SAS][SAS Access Interface to Microsoft SQL Server] A Domain name was specified with both the Domian connection option and as part of the User Name.

The error occurs when you specify the DOMAIN parameter in the data source entry in the odbc.ini file and also specify DOMAIN\USERNAME in the USER= parameter in SAS® software.

To circumvent the problem, specify the domain only once. You can specify the domain in the ODBC data source or in the SAS code using USER="DOMAIN\USER-ID".