I read the DB Setup Instructions… it does not help…
java.sql.SQLException: Network error IOException: Connection refused: connect
The log also states invalid url
Im a novice with Sql… however it should not be this difficult to establish a connection to database…
Openfire and sql are on the same server. I did not create a username or password to access the database… Is it required to create a user account in sql for the connection to be established?? I leave the credintals blank when i try to connect to database
I did a fresh install of SQL 2008 and created an instance named: myopenfire… and database name: openfire… here is what the information look like during the setup wizard:
driver – net.sourceforge.jtds.jdbc.Driver
server – jdbc:jtds:sqlserver://winchi/openfire;appName=jive
I also tried this combination:
driver – net.sourceforge.jtds.jdbc.Driver
server – jdbc:jtds:sqlserver://winchi:1433/openfire;appName=jive
What am I missing??? Please Advise