HRcalendar - Solution To: SQL Server Shuts Down

Issue:

SQL Server will not continue running

A key portion of the Error Message reveals what has happened…

The first line under…

************** Exception Text **************

… states...

“System.Data.SqlClient.SqlException: 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)”

Cause:
Apparently, the system is not responding to TCP port 1433 that is configured for SQL. By default this is not enabled for remote connectivity.

Solution:

To enable the port for remote connectivity please click here.