Supported Driver for MS SQL Server 2014 JIRA

[Deleted user]

Hello,

i am planning to install JIRA on a Windows 2012 server. The MS SQL 2014 database will be installed on a different server, that is not administrable by myself. Therefore I need a very specific specification about setting up the MS SQL server and the database for JIRA. I found a hint that JIRA MS SQL Server 2014 need JTDS driver.

Can you confirm that this driver is needed for running JIRA on MS SQL? Do i need to install this driver on the database server or is this driver already included in JIRA? Can you tell me the specific version of JTDS?

Thanks in advance

Natalie

[Nic Brough -Adaptavist- · Accepted solution]

The installation documentation doesn't hint, it absolutely states that you need the JTDS driver. 

In theory, you could use the MS drivers, but Microsoft have written drivers that are so poorly designed and coded, they are unusable. 

The installer will ask you for them if it needs it, but the right version is bundled with more recent versions.