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!