IntegratedSecurity using MSSQL JDBC

[Former Member]

Hi all,

I am trying to connect from SAP PI 7.31 to a MS SQL database using IntegratedSecurity (Integrated Authentication) in order to avoid the need of update user and password in each communication channel.  Has anyone done that?

I read this help from MS:

http://msdn.microsoft.com/en-us/library/ms378428.aspx

but I have doubts on where should I copy the file sqljdbc_auth.dll.  Also is not clear for me if that is the only file I have to provide.  JDBC driver is already deployed on the system and working fine when using normal user and password.  I am using the option "IntegratedSecurity=true" on the connection string, but the channel is reporting an error with the following exception:

"com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication"

Many thanks in advance.

Nicolas

[Former Member · Accepted solution]

Hi guys,

finally I copied the into "<INSTALL_DIR>\SYS\exe\uc\NTAMD64" and it works now.

I hadn't tried deploying it toghether with the JDBC driver as this system is running on top of MS SQL server so I didnt need to deploy the driver at all as it was already there.

Just one remark for those interested in using IntegratedSecurity, make sure that the DLL you copy in the server is same version that the JDBC driver, in my first try I copied the DLL from the newest available driver (4.0) and it crashed the java stack.  Then I copied the one from the  one corresponding to the installed JDBC (2.0) and it worked fine.

Nicolas

[Former Member · Accepted solution]

Hi Nicolas,

I have also same requirement to connect from SAP PI 7.31 to a MS SQL database using IntegratedSecurity (Integrated Authentication)

"com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication"

Accroding to your suggestion I copied 'sqljdbc_auth.dll' to  "<INSTALL_DIR>\SYS\exe\uc\LINUX86 64" but still I am getting same exception.

This .dll file version is 2.0 according my JDBC driver 2.0

Please suggest me on the same.

Thank you very much.

With Best Regards,

Sateesh

[maheswarareddykonda · Accepted solution]

Hi Sateesh,

Have you checked this Note: https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

BR,

Maheswarareddy

[Former Member · Accepted solution]

Hi, I haven't read it anywhere, but I would expect this only to work if your PI system is running on a windows server, not a Linux one...

[Former Member · Accepted solution]

Hi Maheswar & Nicolas,

Thanks for your suggestions, My PI system is running on Linux version.

I downloaded linux version of  "sqljdbc_auth.dll" file and copied to "<INSTALL_DIR>\SYS\exe\uc\LINUX86 64" .

and also I follwed SAP note also(2063879)mentioned above , but not helps to me my where the file should be copied in case of PI running with Linux version.

Any more hints on this if PI running on Linux version ,If possibility then where I can copied this file 'sqljdbc_auth.dll'?

Thank you.
Sateesh

[Former Member · Accepted solution]

what do you mean by a Linux version of a dll file? As far as I know, DLL are windows binary files. That is why I said that I will never imaging this working on a Linux server.

[Former Member · Accepted solution]

Hi Nicolas,

MS SQL driver version available for both windows and Linux environment.

I downloaded this 4.0 version from this link and I have collected this .dll from 4.0 driver.

Download Microsoft JDBC Drivers 4.2 (Preview), 4.1 and 4.0 for SQL Server from Official Microsoft Do...

Installation Instructions for the UNIX version of the JDBC Driver

• 1. Download sqljdbc_<version>_<language>.tar.gz to a temporary directory.

Thank you.

Sateesh

[asdasd_asdasd · Accepted solution]

For Unix/Linux Platforms check this:

JDBC: This driver is not configured for integrated authentication - CSS SQL Server Engineers - Site...

[asdasd_asdasd]

Check this:

http://msdn.microsoft.com/library/ms378428(v=SQL.90).aspx#Connectingintegrated

"...copy the sqljdbc_auth.dll file to a directory on the Windows system path on the computer where the JDBC driver is installed..."

I try putting the dll in the sda and deploy it.

Regards.

[MichalKrawczyk]

Hi,

>>>but I have doubts on where should I copy the file sqljdbc_auth.dll

have you tried adding it the JDBC driver file (SDA) for MSSQL and deploy again on PI ?

Regards,

Michal Krawczyk

[iaki_vila]

Hi Nicolas,

Have you checked Charu's blog http://scn.sap.com/people/charu.agarwal/blog/2009/07/02/problems-faced-while-connecting-to-sql-serve...?

Regards.

[Former Member]

Hi Iñaki,

thanks for your answer, just checked it but is not helpful in this case.

Nicolas