Newbie having issues connecting to Sql Server

Openfire Openfire Support
1

Hi Im new to openfire and definently not a sql expert either… I followed the instructions for setting up an external database from the documentation page http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html#sqlserver and its all pretty straight forward. However Im getting this error when I finally try to connect (Please see attached Image)… So I go to the error log ( see attached) as it suggests but Im unable to decipher what the issue may be. If anyone is help to help I would be very greatful… Thanks.

openfire.JPG1024×744 91 KB

error.log.zip (4652 Bytes)

2

you 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 go like this

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

heres mine

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