March 24, 2003 at 7:03 am
SQL 2000
Had setup 4 maintenace plans to run at diffrent times (Log backups, optimizations etc.) They ran fine for about a week. Then I had to reboot the server now they will not run. Error indicates owner of the plan does not have server access.
The owner (verified by the msdb table) is an NT 4.0 Domain Administrator. The NT 4.0 Domain Admin group is part of the builtin Admins on the SQL server (win2000) and builtin admins are SQL server admins.
What gives?
March 24, 2003 at 7:21 am
Double click your maintenance plan --> Reporting Tab --> Check 'Write report to a text file' option to log the execution of the maintance plan job. Review the log file for more information why your jobs failure.
March 24, 2003 at 11:31 am
I tried enabling the maintenance plan to create a log as described above. The maintenace plan did not create any log files in the directory when it tried to run.
Still the only clue I have is the following message.
The job failed. The owner () of job Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'1 does not have server access.
March 24, 2003 at 11:39 am
Someone has similar problem and here is the link.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply