I use the SQL Maintenance Plan to generate DB and Trans Logs dumps. The job runs under the authority of the “Admin” account. Generally, the process works fine but occasionally we get:
“The Job Failed. Unable to determine if the owner (<domain name>\Admin) of Job Transaction Log Backup Job for DB maintenance Plan “<machine name> Backup Plan” has server access (reason: Could not obtain information about Windows NT group/user <domain name>\Admin [SQLSTATE 42000] Error 8198).
In other words, NT authentication seems to fail. Anyone had the same experience? Any ideas what’s going on?