Hi I’m trying to set up and configure openfire 3.9.3 locally on Windows 7 and connect to a Windows Azure SQL Server. I have the openfire database setup and configured on Azure but when I use the configuration wizard it just hangs.
To verify that openfire is trying to connect I gave it a bad password and I did get the correct error “org.jivesoftware.database.DbConnectionManager - Login failed for user ‘admin’.” I also to test the connection attempt I closed the firewall for my IP on Azure and it correctly responded to openfire that the client IP is not allowed.
Here is the connection string format that I am using:
jdbc:jtds:sqlserver://[server].database.windows.net:1433;database=openfire;user= ofAdmin@[server];password=[password];encrypt=true;loginTimeout=30;ssl=require
Any help would be greatly appreciated,
Thank You,
Kirk