Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    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)).

    Can somebpody explain me what occured ?

  2. #2
    Join Date
    May 2003

    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.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts