Cant connect to bamboo to MSSQL. Error accessing database: java.sql.SQLException: I/O Error: Connection reset.

Question

I am installing bamboo on a server 2008 R2 server, in the exact same configuration as I have on another server, and I receive "Error accessing database: java.sql.SQLException: I/O Error: Connection reset." Screenshot attached, log directory is blank, so I have nothing to go on.  This same server has Jira and confluence connecting properly to the same database server no problem.

Randy Hentz · Answer

They are all connecting with different credentials.  I have tried everything from both 32bit and 64 bit versions of java 1.7 and 1.6, to tracing the connections. I did a trace and only see an audit login and an audit logout.

Joe Clark · Answer

The screenshot that you attached doesn't seem to be visible :-(

I wonder if perhaps you need to increase the concurrent connection limit on your SQL Server? Are JIRA, Confluence and Bamboo all connecting to different databases using different credentials?

Can you look at the SQL Server event logs to see if there is any indication of a problem?