Hi all,
I am having a heck of a time getting openfire to connect to Db. I have tried every combination of database URL that I can and have read about.
Database URL: jdbc:jtds:sqlserver://0.0.0.0:1433/openfire;appName=jive;instance=sqlexpress
I have used every combination of ip, port, and host name I can think of. I am installing openfire on the same machine that the Db is on. My machine name is chatterbox. I have made sure that TCP/IP, VIA, and Named Pipes are all enabled on the SQL Config. I am using sql auth. and just using sa to access my Db name openfire. I have already ran the query against the Db to put the tables an such in place. Following is the latest error I am getting after attempting to connect. Any help wold be greatly appreciate, as I am at the point of pulling out hair…and I do not do bald very well…LOL.
Thanks in advance for your help.
2012.02.08 15:44:18 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype
java.sql.SQLException: Unable to get information from SQL Server: chatterbox.
at net.sourceforge.jtds.jdbc.MSSqlServerInfo.(MSSqlServerInfo.java:91)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:276)
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)