Good Day Everyone,
I have been attempting to setup Jira Service Desk to interface with our Microsoft SQL Server (2017).
I understand MSSQL 2017 is not Officially supported.
I am facing the issue of JIRA not even wanting to connect to the DB Server, I checked firewalls, connections, ports, everything possible. The database is setup to support v2014.
The Error: [The TCP/IP connection to the host [INTERNAL IP HERE], port 1433 has failed. Error: "Connection refused: no further information.]
I have checked log files, they all describe the same error, without further information.
I can assure you the SQL server is reachable, the correct usernames and passwords were entered, and the Database is setup correctly. I got Confluence to work with it flawlessly on the first try! But Jira Service Desk is puking up errors and I cant seem to find a solution or assistance regarding this topic.
Also this SQL Server is hosted on a Instance, which I was able to input in the Database Connection field of the Confluence installation, but NOT the Jira Application.
I am desperately looking for support, I'd really love to start using Jira at our Company nationwide, this is supposed to be our small scale test, which isn't going very well sofar :(
If anyone has setup Jira with Microsoft SQL 2017 and has it up an running, kindly help a sysadmin out :)
Hi @Marcel Heelein,
can you first check that the server where you want to install Jira has access to your SQL Server instance ? You can test this with telnet:
telnet my.database.ip 1433
This should at least confirm that there are no network issues.
Can you also check what port SQL Server is using ? As you have a named instance, port could be different from the standard 1433.
If this is the case, you don't need to set the instance name in the connection string and will only need to update the port number in the Jira setup page.
Let me know if this helps,
When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event