Skip to Content
avatar image
Former Member

Lumira and Sql Server

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:.....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 20, 2015 at 06:55 AM

    Hi Ben,

        Did you follow the setup procedure described into section 4.1 of the Installation Guide? (create jaas-krb5.conf and the registrey key on the local machine)

    Please follow also  the SAP Note 1768281.

    You can also use integratedSecurity=true into Advanced parameters, this is more like a workaround in case the official SSO solution is not working in your environment (you can keep Use specified username and pwd as connection option, but add integratedSecurity=true into Advanced Parameters)

    Best regards,

    Mihaela

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 08:50 PM

    Hi Ben,

    Are you sure you have correct sqljdbc_auth.dll file? I mean the JVM and DLL files should be compatible with OS 64 bit (X64). make sure these files are not x86.

    Thanks,

    Shailu.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I have tried both but will make sure to keep the x64 version in the same folder as the .exe file.

  • avatar image
    Former Member
    Oct 20, 2015 at 02:48 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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