Linux Server running Confluence 6.11 won't connect to Microsoft SQL Server 2016

[Darryl Hahn]

I installed Confluence 6.11 on CentOs 7.5, and trying to connect it to my database created on Microsoft SQL Server 2016.

Using this Database URL:  jdbc:sqlserver://mysqlserver:1433;database=confluence

I'm getting this error:

Can't reach database server or port

SQLState - 08S01
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host etspsqlprocess, port 1433 has failed. Error: "Connection timed out: no further information.. 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.".

[Shannon S]

Hi Darryl,

It sounds like your Confluence instance isn't able to reach your Microsoft SQL server for some reason.

Can you confirm if you are behind a firewall or proxy? Are you able to access the server using the IP address instead of the domain? If you're behind a proxy please try without the proxy and see if you're able to get through.

Lastly, you could check your Confluence server logs for further details as to what might be occurring.

Regards,

Shannon