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
