on 10-19-2015 8:21 PM
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:.....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i will take a look at the installation guide and get back to you.
i have tried the Integratedsecurity=true method with no luck.
when i use my UID/PW i get a "Login failed for user" error. the current theory is that this is because the way SQL server is configured it requires windows authentication
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.