The status of any task does not update on SMP (Symantec Management Platform) server, there are no NSEs present in Event Queue folder. All the required Altiris services were started on Symantec Management Platform (SMP) server.
Warning in SMP logs:
Task execution engine failed
Failed to construct DatabaseContext object. Connection to database failed.
SQL connection failed, current user=DOMAIN\USERNAME
SQL Server Browser service and SQL Server Agent (MSSQLSERVER) service was stopped on off-box SQL server.
Below steps on SQL Database server will fix the error:
If the following error appears, apply the next steps below: