Unanswered: job failed after domain IP address changed
I've create a maintenance plan using the SQLserver Wizard.
The jobs work correctly until we change the IP address of the server with the following trace :
The job failed. Unable to determine if the owner (DOMAIN\Login) of job Transaction Log Backup Job for DB Maintenance Plan 'BASE' has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\login'. [SQLSTATE 42000] (Error 8198)).
I have seen this a lot on SQL 7 and it seems the NT authentication/ SQL interface neve rreally worked properly.
Easiest way ( and usually the best way of going anyway ) is get sa to own all jobs, then unless its a very secure server, all will run fine and if you change the IP adderess of the server, as sa is local, it wont make any difference.