I have SQL 2005 dev installed on my local computer. I have a few databases, plus the sys databases. I created a maintenance plan to backup all databases. I can back them up manually, but when I execute the maintenance plan manually, I get the following error:
The job failed. Unable to determine if the owner of job MaintenancePlan1 has server access
(reason: Could not obtain information about Windows NT group/user 'username here',
error code 0x54b. [SQLSTATE 42000] (Error 15404)).
I am utilizing windows login security, and my windows login name has been given all admin privileges in SQL.
All help is appreciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.