Lumira and Sql Server

[Former Member]

Hello All,

     i'm trying to connect SAP Lumira (v1.27.1) to Sql Server 2008 using integrated security. I feel like i've googled and tried everything i can think of with little progress...

I've already downloaded the JDBC drivers and placed the sqljdbc_auth.dll file in:

     the same folder as lumira.exe,

     the C:\Program Files\SAP Lumira\Desktop\jre\bin folder

     the same folder as the .JAR file for the driver.

i've tried the integratedsecurity=true in the advanced panel.

i've tried modifying the .ini file to point to the DLL file

and constantly get the following error

com.microsoft.sqlserver.jdbc.SQLServerException: Integrated authentication failed. ClientConnectionid:.....

[Former Member]

Update:

i can connect to a different server with a generic UID. So the question is now what special permissions/config does Lumira need to pull from Sql Server?

[MIH6]

Hi Ben,

  Please also check if sql server has Kerberos enabled and is into a domain. Except this we need to follow the indication from the installation guide, chapter 4.1.

Best,

Mihaela