Hi
I am trying to setup confluence 8.9.0 QA instance. Installed SQL server 2022 db on linux ubuntu 20. Got the user setup with db. When I try to connect via UI from confluence it fails. Throwing below error -
Can't reach database server or port
SQLState - 08S01
com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host localhost, named
instance MSSQLSERVER failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify
the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For
SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
And I have tried connecting to local database using sqlcmd and its working fine
sqlcmd -S localhost -U confluenceuser -P 'confluencepassword' -C
Anyone one know any solution or have faced this problem?