In sql error log ( SQL 2008 R2) I notice that we keep getting this same issue "
" Login failed for user ABC\xxx"
Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: ..........] .
AUthentication is mixed mode
I checked in Solarwind and user ABC\xxx is there ( crossed with blue pen
I am wondering why this happen . Any feedback is much much appreciated !
Found the Issue :-)
The account needs to be granted 'Log on as a Batch Job'
I'm all working now :-)