nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

wajdhaikal

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.

All comments

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.

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?

wajdhaikal

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)

unknown

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

For the "Database Connection" select "My Own Database"
For "Database Type" select "Microsoft SQL Server"
For "Hostname" enter "myServerName"
Leave "Port" as "1433"
For "Database" enter "myDbName;instance=myInstanceName"
Fill in "Username", "Password" and "Schema"
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.

Nicholas Del Co

Chris Gill method works. thanks

SamNg-3DP

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira