Symptoms
Over the weekend our Database Support Group upgraded out SQL Server 2014 environment to SQL Server 2016. When we reviewed their work this morning, we find that the Development Environment is no longer functioning.
When we try to access the designer web site we get the following error:
Server Error: No connection could be made because the target machine actively refused it [IP Address]:5555
When we try to access the workspace site we get the following error:
An error has occurred.
Please contact your administrator.
Error:
Initialization failed before PreInit: Membership could not be verified: Cannot generate SSPI context.
When we recycle the K2Services on development we get the following error.
1005 Initializing Connection to Host Server Database: SQLK2DB
2005 Error Connecting to Database, Will Retry in 30 Seconds,
When attempted to run the setup tool, the tool is failing to recognize/connect to the database server.
Diagnoses
The issue was caused by SQL remote connection was not enabled via TCP port 1433
Resolution
Follow the following reference to resolve the issue:
https://www.nextofwindows.com/how-to-setup-sql-server-remote-connection-and-why-its-not-listening-on-port-1433