Openfire and Microsoft SQL

Openfire Openfire Support
1

Hi All

Is there a working version of OpenFire that can use a named instance of a Microsoft SQL server, as all I get back is “Unknown server host name ‘server\instance’.”

I have tried all the following,

server\instance

localhost\instance

127.0.0.1\instance

server.local.domain.com\instance

server.local.domain.com\instance

If I manage to connect, has the maximum key length problem been sorted?

Thanks

–

David

2

you may have to set your sql instance port from dynamic to something static. If its the only instance on the server, than you can use the default port of 1433. If its not the only sql instance, than you may want to use something else, like 2433.

then your connector setting should look like this. notice the (:slight_smile: after the port number!! very important!

jdbc:jtds:sqlserver://SERVER_NAME:PORT#:/INSTANCE_NAME;appName=DATABASE_NAME

heres mine

jdbc:jtds:sqlserver://server1:2433:/sqlexpress;appName=openfire