powered by Jive Software

Newbie question: Database Settings - Standard Connection to Windows Azure SQL Server hangs

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,