JIRA Installation on Windows Server 2008 R2 standard and SQL server 2008 R2 on same local machine

[wajdhaikal]

JIRA Installation wizard database configuration step does not see the local SQL server 2008 R2 Host, even all services are running:

Error:

Error connecting to database

Unknown server host name 'JIRA\JIRA44'.

JIRA\JIRA44

What could be the cause?

do i need to install any driver , advice please!, I did the same installation on windows server 2003 worked.

[wajdhaikal · Accepted solution]

I have resolved the problem by installing a default instance (not a named instance) this solved my issue, it seems JIRA database configuration page has problem dealing with a named SQL instance.

[wajdhaikal]

This does not have any relation with the release of SQL server if 2005 or 2008..etc. I have made many senarios and tests to enable JIRA to see the 'NAMED' instance of SQL server and all tests failed to see the named instance. The default SQL server instance worked fine in all SQL server versions.

[wajdhaikal]

if you think this is possible, then kindly send me a configuration file/xml (JIRA use with a "Named" SQL server instance)

[Deleted user]

If you want to connect to myDbName on myServerName\myInstanceName then during initial setup (just after installation) try the following field values:

1. For the "Database Connection" select "My Own Database"
2. For "Database Type" select "Microsoft SQL Server"
3. For "Hostname" enter "myServerName"
4. Leave "Port" as "1433"
5. For "Database" enter "myDbName;instance=myInstanceName"
6. Fill in "Username", "Password" and "Schema"
7. Click "Test Connection"

The alternative is to manually configure the dbconfig.xml file as described by Atlassian but modifying the <url> tag as described in the JTDS FAQ. This information is available from Atlassian, but is tagged for SQL Server 2005.

[AZ]

Your solution works great Chris. It was driving me nuts. Many thanks.

[Nicholas Del Conte]

Chris Gill method works. thanks

[SamNg-3DP]

Great tip, @Chris Gill!! Worked perfectly. Thank you.

[Andrew Frayling]

JIRA does support instance names, does http://confluence.atlassian.com/display/JIRA044/Connecting+JIRA+to+SQL+Server+2008 help? Section 4.2 gives an example of using a named instance.

[wajdhaikal]

My server is windows server 2008 R2 ( 64 bit )

Ihave installed JIRA as a service using installer package.

Im unable to run the conf.bat from command prompt to configure the database (it popups and close)

Is this has any relation with tomcat?

[Nic Brough -Adaptavist-]

Check the name of the database server - are you sure it's listening there? (The string doesn't look right to me, but it's been a while since I used MS SQL)

[wajdhaikal]

If I removed instance name, it will give me this error:

Error connecting to database

Network error IOException: Connection refused: connect

Connection refused: connect

[wajdhaikal]

uanforunatly not, because this is an instance Hostname : JIRA and instance name JIRA44

my question is, is jira_user must exist because Im binding and using sa user for my installation and connecting via sa user and dbo schema.

[Nic Brough -Adaptavist-]

Can you connect to it using another tool? There shouldn't need to be anything other than an empty schema for Jira to use (your JIRA44) and a user for it - check that you can connect with the explorer or something.

[wajdhaikal]

not solved yet. does JIRA support Sql instance , or just default instance

[Nic Brough -Adaptavist-]

Yes, it does, it works fine on at least two installs I have access to. You are not configuring it correctly.

Please check your settings and re-read the documentation Andrew pointed to. Then tell us what you are doing differently from that, or go into more detail about what you're putting in and how you've configured it.