powered by Jive Software

Database connection failure

I have configured my server named “SERVER2K8” which has SQL Server 2008 R2 installed. I have created a database named “openfire” and it has an owner/user named “of_owner” which is user mapped to the “openfire” database. When I run through the OpenFire setup, on the Database Settings page, it has autofilled the following information (I have inserted my own server name and database name as instructed):

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

Database URL: jdbc:jtds:sqlserver://SERVER2K8/openfire;appName=jive

Username: of_owner

Password: ***********

Minimum Connections: 5

Maximum Connections: 25

Connection Timeout: 1.0 Days

When I select “Continue” I get an error:

“A connection to the database could not be made. View the error message by opening the “\logs\error.log” log file, then go back to fix the problem.”

The log file contains:

2010.07.22 12:38:24 [org.jivesoftware.util.log.util.CommonsLogFactory$1.error(CommonsLogFactory.jav a:92)

] Prototype

java.sql.SQLException: Network error IOException: Connection refused: connect

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:385)

at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

Caused by: java.net.ConnectException: Connection refused: connect

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(Unknown Source)

at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:3 04)

at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:255)

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:310)

… 8 more

Any and all help getting this resolved would be greatly appreciated!! Thanks in advance!


do you use a firewall on your server? Try to run “telnet SERVER2K8 1433”, this should give you a connection. Is this a remote server or do you ran the database on the same host (then use Do you use the standard port 1433?


sql2008 uses dynamic ports. you’ll need to disable dynamic ports , and set it to a static port.

1 Like