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!

Hi,

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 127.0.0.1:1433)? Do you use the standard port 1433?

LG

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

1 Like