On this page:
- Before you start
- Setting up the JIRA database
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.
Before you start
1. Enable network connectivity for SQL Server
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,
2. Configure SQL Server with the appropriate Authentication Mode
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.
3. Disable the 'SET NOCOUNT' option in SQL Server
To disable the 'SET NOCOUNT' option in SQL Server,
Setting up the JIRA database
To set up your JIRA database for SQL Server 2005,
1. Create a new database
2. Create a new database user
3. Create a JIRA database schema
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.