- Install your JIRA with run as service option
- Stop the JIRA server.
- Download the Microsoft SQL Server JDBC Driver 3.0
- Run sqljdbc_<version>_enu.exe
- 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 - 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. - 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
- Add your service account to the administrators group of the JIRA server.
- Change the account of the jira windows service to the above service account.
- 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>
- 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
