MII 15 connecting to transactional SqlServer DB with windows authentication

[Former Member]

Hi

I currently have an issue whereby I want to connect from MII via an IDBC(SQL) connection to a windows 2012 SqlServer database that only uses Windows Authentication. Is this something that is possible.

All the documentation I have seen suggests that SQL authentication should be used for the connection.

We are using sqljdbc4.jar jdbc driver, which we know works successfully on SQL authentication.

Is this possible, has anyone been successful ?

thanks.

[former_member185280]

From a quick scan of the Microsoft jdbc docs it looks like it could be possible but I have never come across anyone doing this from Netweaver/MII. Go for it and let us know how it goes.

Regards,
Christian

[lawrence_prinsloo]

Hi all,

any feedback on this?  Is it possible to use a different JDBC driver?

[Former Member]

You can enable SQL authentication on the database server. If that's not possible, try jdbc:sqlserver://localhost;integratedSecurity=true;

and copy the appropriate DLL (sqljdbc_auth.dll provided with the driver) in the JVM path somewhere. You have to configure the user with which the JVM is started to be different from the local account and it should have enough rights to connect to the SQL machine if the host is different .

If it's not working due to the windows settings on that machine (the DLL has to be reached by the java environment running the connector) and you can't change them, try use jTDS driver: jTDS JDBC Driver

Read the README.SSO file in the jtds distribution on how to configure for single-sign-on (native authentication) and where to put the native DLL to ensure it can be loaded by the JVM.

You're out of luck if you host SAP NW+MII on a non-windows platform.

[lawrence_prinsloo]

great thanks very much!

[Ahmet]

Hi

Were you able to solve the connection issue?