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, Panel |
---|
borderColor | #CCCCCC |
---|
bgColor | #FCFCFC |
---|
| - Open the 'SQL Server Configuration Manager'.
- Expand 'SQL Server 2005 Network Configuration' in the console pane.
- Click 'Protocols for <instance name>'.
- The details pane will display (see screenshot below). Right-click 'TCP/IP' and click 'Enable'.
- Click 'SQL Server 2005 Services' in the console pane.
- The details pane will display. Right-click 'SQL Server (<instance name>)' and click 'Restart' to stop and restart the SQL Server service.
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, Panel |
---|
borderColor | #CCCCCC |
---|
bgColor | #FCFCFC |
---|
| - Open the 'SQL Server Management Studio'
- Navigate to ''Tools' -> 'Options' -> 'Query Execution' -> 'SQL Server' -> 'Advanced'. The advanced settings for SQL Server will display.
- Ensure that the 'SET NOCOUNT' option is not selected, as per the screenshot below:
Screenshot: Disabling 'SET NOCOUNT' for SQL Server |
|