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

This widget could not be displayed.

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.

http://msdn.microsoft.com/en-us/library/ms177440.aspx

This may also explain Microsoft Firewall issues.

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

thx. that worked fine

This widget could not be displayed.

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.

This widget could not be displayed.

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.

Cheers,
Septa Cahyadiputra

This widget could not be displayed.

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

This widget could not be displayed.

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

150 views 16 7
Join discussion

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