Can OpenFire support Sql Server 2008 Express R2?

Openfire Openfire Dev
#1

I have tried to make sql server 2008 express r2 as the external database for Openfire server?

but when I configure the connection in the wizzard,it always report can not connect to the database server,

I 'm very sure the user name and password and the option driver class I have select the correct one (like the document said),and

the database is available for connection.

So can you help to identify what’s the issue?

Regards,

#2

Try making your serverURL similar to this; SQLExpress uses “instances” (I think so it can be installed with standalone apps).

jdbc:jtds:sqlserver://SERVER/openfire;appName=jive;instance=SQLExpres s

#3

You are Great ,Michael !

It works like a magic!

1 Like
#4

This solution didn’t work for me, unfortunately. This is a Windows Server 2008 R2 with SQLExpress R2 installed. It is not a domain and not joined to a domain. In fact, it’s a Hyper-V virtual machine to be precise.

I’ve tried using the direct IP address, localhost, instance=SQLEXPRESS at the end, nothing works. I’m going to attach my error log. Maybe someone can shed some light on this? I am also using the default Sql account sa.
error.log.zip (1427 Bytes)

#5

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. 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

#6

This is the only instance on this server. Now, as I was looking at the IP’s through the SQL Configuration Manager, It lists IP’s from IP1 through IPall. Which IP needs to be static? 127.0.0.1?

#7

One other thing, I also noticed that for each IP, there set to Active=Yes, but Enabled=No. And the TCP/IP Properties status is Disabled. Does any of this also have to be changed?

#8

yes…enable tcp/ip protocols for your instance, (you’ll have to restart your services after making this change) then make sure your tcp port is 1433 in all the fields.

#9

I enabled everything. The tcp/ip protocols, all IPx’s are Active and Enabled, every IPx has the TCP Dynamic Ports “0” removed and every IPx TCP Port has been set to 1433, SQL Server service has been restarted and still cannot connect to the database. Here is my error log again. I am at a loss. I’m starting to think about dropping this and go with a different product. Everyone said this was a easy install. Now, I’ve wasted half my day yesterday and now almost all my morning. Here is my configuration:

Database Driver Presets: Microsoft SQLServer

JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver

(This one, I have tried many different configurations) Database URL:

jdbc:jtds:sqlserver://localhost:1433:/sqlexpress;appName=openfire_server

jdbc:jtds:sqlserver://209.223.xxx.xxx:1433:/sqlexpress;appName=openfire_server

jdbc:jtds:sqlserver://name of server here:1433:/sqlexpress;appName=openfire_server

Username: sa

Password:XXXXXXXXXX
error.log.zip (1892 Bytes)