Jira 4.4 with MS SQL Server and Integrated Security

1. Install your JIRA with run as service option
2. Stop the JIRA server.
3. Download the Microsoft SQL Server JDBC Driver 3.0
4. Run sqljdbc_<version>_enu.exe
5. Enter an install directory when prompted; it is recommended that you unpack this zip file in %ProgramFiles% with the default directory:
   Microsoft SQL Server JDBC Driver 3.0
6. Copy C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar to C:\Program Files (x86)\Atlassian\JIRA\lib or your [JIRA installation dir]/lib
   note: if you use JDK 6.0 or above, you need to use sqljdbc4.jar.
7. Copy C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\auth\x86\sqljdbc_auth.dll to C:\Program Files (x86)\Atlassian\JIRA\bin or your [JIRA installation dir]/bin
8. Add your service account to the administrators group of the JIRA server.
9. Change the account of the jira windows service to the above service account.
10. Change the C:\Program Files (x86)\Atlassian\Application Data\JIRA\dbconfig.xml or  your [JIRA Application Data dir]/dbconfig.xml as following, the username and password need to be set, but a random string is ok. JIRA will check these two properties when starting the server.
    

    <?xml version="1.0" encoding="UTF-8"?>
    
    <jira-database-config>
      <name>defaultDS</name>
      <delegator-name>default</delegator-name>
      <database-type>mssql</database-type>
      <schema-name>dbo</schema-name>
      <jdbc-datasource>
        <url>jdbc:sqlserver://dbserver:dbport;databaseName=dbname;integratedSecurity=true</url>
        <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
        <username>user@domain</username>
        <password>ooxx</password>
        <pool-size>15</pool-size>
      </jdbc-datasource>
    </jira-database-config>




11. Start  the JIRA server

Note:

• Not sure why the x86 version of  sqljdbc_auth.dll is required, although both my windows and JDK are x64 editions. but x64 version of sqljdbc_auth.dll just does NOT work.
• This only applies to JIRA 4.4. For JIRA 4.3, some file location is different. for example dbconfig.xml