Documentation for JIRA 4.1. Documentation for other versions of JIRA is available too.
On this page:
This page supplements the documentation for Connecting JIRA to SQL Server 2005. It provides detailed instructions on setting up your JIRA database for a straightforward integration of JIRA with SQL Server 2005. Unfortunately we do not provide support for advanced database configuration, such as hardening or performance tuning. If you require a more complex solution, refer to MS SQL 2005 Documentation and, if necessary, consult with someone in your organisation who is knowledgeable in the configuration of SQL Server 2005.
Ensure that your instance of SQL Server allows TCP/IP connection and is listing on the default port. Please note that network connectivity is disabled by default in some versions of SQL Server (e.g. SQL Server 2005 Express edition). Hence, you will have to enable it, as described below:
To enable TCP/IP for SQL Server,
Screenshot: Enabling TCP/IP for SQL Server 2005
Ensure that SQL Server is operating in the appropriate authentication mode. By default, SQL Server operates in 'Windows Authentication Mode'. However, if your user is not associated with a trusted SQL connection, i.e. 'Microsoft SQL Server, Error: 18452
' is received during JIRA startup, you will need to change the authentication mode to 'Mixed Authentication Mode'.
Read the Microsoft documentation on authentication modes for instructions on changing the authentication mode.
To disable the 'SET NOCOUNT' option in SQL Server,
Screenshot: Disabling 'SET NOCOUNT' for SQL Server
To set up your JIRA database for SQL Server 2005,
Congratulations, you have set up a JIRA database for SQL Server 2005. Please refer back to the Connecting JIRA to SQL Server 2005 page to continue integrating SQL Server 2005 with JIRA.