Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Unable to connect to new JIRA Server to Microsoft SQL Server locally

I am installing from scratch JIRA, and I can't get it to connect.

It is SQL Server 2017, and I have tried all combinations for the named instance. The weird thing is that a few minutes ago I installed Confluence and it worked fine. So the database  configuration is correct and the ports are open. There is no support for starter licenses, so can anyone help me here? Thanks in advance.

This is the error I get

Error connecting to database

The TCP/IP connection to the host ALPHARETTA/BIGDATAINC, port 1433 has failed. Error: "ALPHARETTA/BIGDATAINC. 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.".

And I am trying in  every possible way

jira.png

2 answers

0 votes

Hi,

did you try a 'netstat -an' to check of the MSSQL server is listening to the port & ip you specified. Does your name resolution work? ping MYSERVER

I guess you're not using the express version which is not supported.

Best

JP

0 votes

Ah,

and another hint:

Hostname is for a hostname or ip address and not for a SERVER/INSTANCE scheme.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

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...

4,346 views 22 31
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you