Unable to connect to SQL Server database in JIRA Installation. Need to open any firewall port??

[Sravya Vuggina]

I have ensured that TCP/IP is enabled in SQL Server Configuration Manager. However, I get the below error message. Am I missing something here?? 

 

[Dave · Accepted solution]

Hi Sravya,

If your database is on a different server to your Jira, you will need to make sure that the database server has port 1433 open for the Jira server to communicate.

You can telnet to see if the port is open for your Jira server -

On Jira server (if Jira is on Windows server you may need to install telnet)

telnet database.server.ip 1433 

or on same server as Jira

telnet 127.0.0.1 1433

If this comes back that its refused, then definitely needs to be opened on the database server side firewall.

If database is on the same server as Jira and telnet connection is refused, it may be that your sql server database isn't actually running on 1433 port. Then you will need to check what port its running on.

Hope this helps 

[Sravya Vuggina]

Hi David,

Thanks much for the response! 

You were right, Sql Server database wasn't running on 1433 port. During the installation I have mentioned the port of database server and it worked.