Connect to SQL 2017

[Joseph McGinty]

I am trying to stand up Confluence with a SQL 2017 Database and I keep running into the below error: 

Can't reach database server or port

SQLState - 08S01
com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host sql01.kaisha.systems, named instance KAISHASQL 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.

I've verified that UDP 1434 is open on both systems both outbound and inbound as well as making sure that the TCP/IP and NamedPipes are enabled in the SQL server, and that the default port on SQL is set to 1434

[JP _AC Bielefeld Leader_]

check this answer:

https://community.atlassian.com/t5/Jira-Software-questions/How-to-setup-Jira-with-Microsoft-SQL-Server/qaq-p/834891

Best

JP

[Joseph McGinty]

Looked like that one was pointing to ports, which I've already verified that the ports for confluence were set up as the ports for the instance in sql.