Database server is not available: 5051 ERROR_DB_UNAVAILABLE (get operation failed: Network error IOException: Connection refused: connect)

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Setup jtdc sql server
2. Open up port 1433 in firewall settings 
3. Connect to the sql server

What is the expected output? What do you see instead?
Expected : No databasw WARN in health check
Getting an error : Database server is not available: 5051 ERROR_DB_UNAVAILABLE 
(get operation failed: Network error IOException: Connection refused: connect)

What ldap directory and version are you using?
MS Active directory

Please paste any error log messages below:

Original issue reported on code.google.com by madhura....@gmail.com on 7 Feb 2013 at 7:14

[GoogleCodeExporter]

This just meas that it can't connect to your database.  Check all your ports in 
any firewalls, etc.  This is not a PWM issue.

Original comment by bscha...@gmail.com on 5 Mar 2013 at 4:48

[GoogleCodeExporter]

Original comment by jrivard on 11 Mar 2013 at 5:42

• Changed state: Invalid

[GoogleCodeExporter]

Here are some more specific settings we utilized to resolve this error with 
JTDC  and PWM using MS SQLExpress:

Database Class:
net.sourceforge.jtds.jdbc.Driver

Database Connection String:
jdbc:jtds:sqlserver://<server>:1433/<database>;instance=SQLEXPRESS

or (if using a Windows Active Directory domain acct to for this connection)

jdbc:jtds:sqlserver://<server>:1433/<database>;instance=SQLEXPRESS;domain=<WinAD
domain>

Additionally:
(1) in SQL Server Configuration Manager, check "SQL Server Network 
Configuration/Protocols for SQLEXPRESS" -- verify TCP/IP is enabled
(2) in Windows Services -- verify service "SQL Server Browser" is running and 
set to automatic or manual start

Original comment by bleon...@extremereach.com on 20 Jan 2015 at 6:49