powered by Jive Software

User Auth with SQLServer 2005

Hi,

We’re trying to get OpenFire to authenticate users against our MS SQLServer 2005, but keep failing. It seems the connection does not reach the server at all (as we can clearly see in the SQLServer profiler tool).

We have no problem connecting to a MySQL DB, but for some wierd reason it just does not work with SQLServer.

Below is the connection string we’re using.

jdbc:jtds:sqlserver://<OUR-DB-NAME>/<OUR-INSTANCE>?user=<DB-ADMIN-USERNAME>&password=<DB-ADMIN-PASSWORD>;appName=jive

Does someone have a clue?

Thanks in advance!