Error: "SQL connection failed, current user=<Domain>\<ServerName>

Products

• IT Management Suite

Issue/Introduction

Logs are filling with loads of errors. 

Module: Altiris.TaskManagement.dll
Source: Altiris.TaskManagement.ServerTasks.ServerTaskManager.RunTaskExecutionEngineLoop
Description: Failed to start tasks - database is not ready.

Failed to construct DatabaseContext object. Connection to database failed.

SQL connection failed, current user=<Domain>\<Hostname>

Environment

ITMS 8.x

Cause

The Altiris Client Task Data Loader Service account was changed from Local System to Network Service. 

Resolution

Change the Altiris Client Task Data Loader Service back to run as Local System. In addition, make sure other services are using correct domain accounts so it's possible for task service to impersonate the Altiris services account when necessary: