powered by Jive Software

Database connection with AD user

Dear all,

we are using openfire 4.4.4 on Windows Server 2012 R2. We tryed to connect to our Database with AD Account (see the screenshot below).
Do you have any idea how we can connect to our Databse with AD-user?

This setting do not work.

Kind Regards
Mario Feyen

This is a bit more complicated to do with the microsoft jdbc driver.
The easy thing to do would be to switch driver to the microsoft legacy one (jTDS). Then at the end of your url as ;domain=DOMAIN
then type in the username and password

If you want to use the microsoft driver, than you’ll need to download a dll from microsoft and add a few more options to the url string

Can you tell me, which dll from microsoft we need and which options we need to add then to the url string?

https://www.microsoft.com/en-us/download/details.aspx?id=57782
here you go. inside the pack is a dll called sqljdbc_auth.dll extract the correct one for your arch. likely x64.
prob drop this file into windows/system32.

and I think you’ll want to then add integratedSecurity=true;authenticationscheme=NTLM;domain=DOMAIN

I haven’t tested this, but you should be able to find additional information on microsoft
https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15