We are running Jasperserver Professional 5.6 on a Windows Server 2012 R machine. We receive the following error message:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xx.xx.x.xxx, port 1433 has failed. Error: "No buffer space available (maximum connections reached?): connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."
Increasing the number of sockets to 65000 helped for a while. The error is now reoccuring. Is there a fix for this issue?
Have you using the most recent jdbc drvier from MS?
Have you tried decreasing timewait?
If you had, try contacting MS or posting your question to the MS forum because it seems like a bug with SQL Server.