Why can't I connect to the MS SQL server

Question

I'm trying to migrate to mssql Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 Datacenter 6.2 (Build 9200: ) (Hypervisor) I have tried different ways Without port With port Attempting to connect to the SQL Server database server... Could not connect to the DB: The TCP/IP connection to the host mysqlserver, port 61397 has failed. Error: "Connection refused: 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.". If I use a local ms sql server, there is no problem Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) Please help to solve the problem

Andy Heinzer · Accepted Answer

Your error messages just indicate that the Jira application can't connect to this database server.  It could be that there is a firewall in place, or that there are different settings within MS SQL in regards to which ports/addresses you can access that SQL server on.

I'm afraid your screenshots have obscured a bit more information that I wanted to see to be more helpful here.  But take a look at this KB from Blackbaud:  How to find the port being used by SQL Server

It provides detailed steps you can take on the SQL server side (you will need admin rights there) in order to see exactly how the SQL server is configured in regards to address and ports it's listening on.    You will need to make sure that this server is using an interface and a port number that can be access from the Server running Jira.

It is also possible that you will need to walk through this MS document on Configure the Windows Firewall to Allow SQL Server Access

Since it sounds like the SQL server you want to use is not on the localhost, you will need to make sure that the SQL server has opened up the necessary ports so that your Jira server can reach it.