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)).
Can somebpody explain me what occured ?Howdy
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.
Cheers
SG.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment