Windows Server + MS SQL Server 2014 + jTDS Edited

Hi, this is probably a pretty simple question that i dont seem to find details on how to do.

I have downloaded the jTDS 1.3.1 and now i would like to know how to install this driver and make Jira Core 7.4.2 detect in during the setup phase and make the test connetion succeed.

Have seen that i just drop some files in some folder, but not sure which files and where.

Anyone.. help. please

 

/Micke

1 answer

0 votes

I think you might have found old outdated docs here.  If JIRA needs a database driver for your system, it will tell you how to install it and where as you run the installer (when it needs it, it really is "download one jar file, move it to directory given on screen").  You'll need to restart the installer after moving the file.

ah.. ok.

When i have you "on the line".. do you know if there is anything special i need to do to get the AD service user to work when connecting to the database. When i test the connection i get "Error connecting to database. Login failed for user serviceaccountname" I workes if i use a local sql user.

According to this documentation from Atlassian (7.4).

SQL Server 2014 needs the driver. https://confluence.atlassian.com/adminjiraserver074/supported-platforms-881683157.html

Microsoft SQL Server
•2014
•2012
 •Express Editions are not supported.
•Supported Microsoft SQL Server databases use the latest JTDS JDBC driver listed here.
 

I don't know how a service user would be used to connect to an AD server, but it sounds like the AD server is not expecting that format of connection, or the credentials are wrong, or it's not configured to let that user in.

Its not supported by Atlassian, so either workarounds are necessary or wait until supported by Jira. I will wait. Voted up this is also possible right now

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

726 views 5 16
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