setting up integratedSecurity in dbconfig.xml

[Tom Lister]

upgrading from 4.0.1 to 4.4 can't get connection to work.

I have two JIRA services running as ants\svc_cc_jira_dev

Version 4.0.1 uses standard tomcat configs to set up a connection and it works

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"

driverClassName="net.sourceforge.jtds.jdbc.Driver" domain="ants"

url="jdbc:jtds:sqlserver://gblondb018:1513/ccjiradb;tds=8.0;lastupdatecount=true;integratedSecurity=true" />

Version 4.4 uses its own config and I get the error

“The login is from an untrusted domain and cannot be used with Windows authentication.”

<jira-database-config>

<name>JiraDS</name>

<delegator-name>default</delegator-name>

<database-type>mssql</database-type>

<schema-name>ccjiradb</schema-name>

<jdbc-datasource>

<url>jdbc:jtds:sqlserver://gblondb018:1513/ccjiradb;tds=8.0;lastupdatecount=true;integratedSecurity=true;domain=ants</url>

<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

<username>blah</username>

<password></password>

<pool-size>15</pool-size>

</jdbc-datasource>

</jira-database-config>

[Ribbles · Accepted solution]

I got integrated security working with JIRA v5.17 with a domain user.

I had to switch to MS JDBC:

1. Downloaded sqljdbc_4.0.2206.100_enu.exe from Microsoft
2. Copied sqljdbc4.jar to Atlassian\JIRA\lib and Atlassian\JIRA\atlassian-jira\WEB-INF\lib
3. Copied x86\sqljdbc_auth.dll to Atlassian\JIRA\bin and Atlassian\JIRA\jre\bin and C:\Windows\System32

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mssql</database-type>
  <schema-name>jira</schema-name>
  <jdbc-datasource>
    <url>jdbc:sqlserver://server:1439;databaseName=APP_JIRA;integratedSecurity=true;domain=MYDOMAIN;</url>
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
    <username>MYDOMAIN\user</username>
    <password>P@$$w0rD</password>
    <pool-size>15</pool-size>
    <validation-query>select 1</validation-query>
  </jdbc-datasource>
</jira-database-config>

The extra paths I copied the jars/dlls to may be redundant, as too with the user/pass in the XML.

[Tom Lister]

This looks promising

https://confluence.atlassian.com/pages/viewpage.action?pageId=262471708

it seems to have connected according to the logs

:-)