• Community
  • Questions
  • Running Jira on same server as MS SQL 2008R2. Trouble with install SQL Server.

Running Jira on same server as MS SQL 2008R2. Trouble with install SQL Server.

Wanted to use a MS Sql developer instance already running on this same machine. How do I get the installer to recognize it?

Update: the real problem is I can't get the configurator to log into my SQL2008 instance. Keep getting

error connecting to database

Network error IOException: Connection refused: connect

Connection Refused: connect

I'm perplexed by this as an ODBC connector from another machine for the same instance works fine (different database and all that.)

5 answers

1 accepted

Ugh, this just makes me sad.

The error I was seeing was assuming MSFT SQL2008 always uses TCP port 1433. Bad assumption.

Launch SQL Server Configuration Manger on the server to verify your port.

The list on the left side of the screen: [SQL Server Network Configuration] < click on to open

[Protocols for <hostname>] On the right menu there is a list of protocols that have to be configured.

[TCP/IP] < make sure it is Enabled. Then, menu click to open TCP/IP Properties.

at the bottom of the list: IPAll, in my case, had port 49212. Plugging that into the JIRA Configuration finally allowed "Test Connection" to work.


This may also explain Microsoft Firewall issues.

Well, now I just have to figure out the schema.

thx. that worked fine

Hi, if you are just testing why not use the built-in database? HSQLDB. It'll be much easier.

And or otherwise, https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2008 - instructions for SQL Server + JIRA.

Hi Robert,

Once the installer finished installing JIRA on your machine, you should be able to access JIRA setup wizard on your browser which will guide you to finish and configure your JIRA installation.

You can configure the database configuration on this setup wizard.

Hope it helps.

Septa Cahyadiputra

Changing Hostname in SQL setup was causing updates to the error message. My mistake.

localhost and the machine name both worked and weren't the problem.

"Error connecting to database"

"Network error IOException. Connection refused: connect"

Instructions might need updating thanks to changes on MSFTs end. Set up a new schema in MS SQL 2008. The database has a security schema. But, your example screenshot just has "public".

If you're installing JIRA on the same machine as MS-SQL2008, you will want to avoid the horse-race condition that causes Jira to fall over because SQL isn't fully awake.

After things are running, go into Control panel, Services, and open Properties on Atlassian Jira, which should currently be set for Automatic and Running.

Change that to Delayed Start.

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

194 views 6 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot