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.)
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.