Error 500.0 accessing Jira Align Self-Hosted if SQL server is not configured to allow remote connections
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
After installing Jira Align On-Premis, a 500.0 error is returned by IIS when accessing the Jira Align website
Environment
Jira Align Self-Hosted
Diagnosis
The following error is displayed when accessing the site:
HTTP Error 500.0 - Internal Server Error. The page cannot be displayed because an internal server error has occurred
The following error is found in Microsoft Windows Event Viewer > Windows Logs > Application
1
2
3
4
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Open image-20230203-150453.png
Cause
This error can occur if the SQL Server is not configured to allow remote connections, which prevents the Jira Align web server from establishing a connection to the database.
Solution
Login to the Jira Align Database server
Open SQL Server Configuration Manager
Navigate to SQL Server Network Configuration > Protocols for MSSQLSERVER and ensure all associated protocols are enabled:
Right-click TCP/IP, selectProperties and click the IP Addresses tab. Ensure the source IP address of the Web server is Active/Enabled and the proper TCP Port is selected.
Click OK to save changes.
Navigate to SQL Server Services, right-click SQL Server (MSSQLSERVER) and choose Restart.
Once the service is restarted, try accessing the Jira Align instance in a fresh browser session.
Was this helpful?