Openfire issue with SQL authentication

General Discussion
1

I am installing and configuring Openfire with connectivity to an external MS SQL DB.

I have a domain account created for this purpose and when I add the account details during Openfire setup DB connectivity fails every time.

I have looked at the logs on the SQL server and I can see the Openfire login attempts failing because they are trying to authenticate using SQL authentication rather than Windows authentication, but I cannot see how/where on Openfire I tell it to use Windows authentication.

Can anyone of you help ?

TIA

2

I think you have to add the domain property to your connection string. so your string might look something like this

jdbc:jtds:sqlserver://localhost/openfire;domain=domain.local

jTDS JDBC Driver