1768281 - SAP Lumira Desktop displays Error "This driver is not configured for integrated authentication" when connecting to SQL Server using integrated Authentication

Error "This driver is not configured for integrated authentication" is received when validating a connection in SAP Lumira Desktop against Microsoft SQL Server using integrated security.

• Windows 2008 R2
• MS SQL Server 2008
• SAP Lumira Desktop

1. Open Lumira Desktop.
2. Click New Document.
3. Select Free hand SQL.
4. Expand Microsoft.
5. Select MS SQL Server 20## - JDBC where ## is your version of MS SQL
6. Enter your log in information.
7. Select the ADVANCED tab
8. In the JDBC Driver Properties... box enter integratedsecurity=true
9. Click Validate connection

This is due to SAP Lumira Desktop being unable to load the SQL JDBC authentication library, sqljdbc_auth.dll.

1. In Windows Explorer navigate to the directory <MS JDBC installation directory>\sqljdbc_<version>\<language>\auth\x64 for example C:\Program Files\Microsoft JDBC DRIVER 4.0 for SQL Server\sqljdbc_4.0\enu\auth.
2. Right-click  sqljdbc_auth.dll and select copy.
3. Navigate to C:\Program Files\SAP Lumira\Desktop.
4. Right-Click this directory and select paste.
5. Restart Lumira and try to make this connection again.
6. If the same error is displayed then copy the sqljdbc_auth.dll to the <SAP Lumira>\Desktop\jre/bin directory.

NOTE: This resolution is a workaround, is not officially supported by SAP, and will only work on Lumira Desktop.

There is no comparable workaround if the same error occurs in the Launchpad.

MSDN Article Building the JDBC Connection URL

Visual Intelligence, VI, JDBC, Integrated Authentication, AD , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem