|
I have created a maintenance plan but when I try to execute I get the error: I have given administrator db owner access but still get the error, what am I doing wrong?
| |||
|
feedback
|
|
Usually when this happens you just need to edit the job and save it again. This will "usually" fix the problem. Failing that try changing it to run under a SQL Account such as the sa account so that it doesn't need to check for domain credentials before running the job. | |||
|
feedback
|
|
Those maintenance plans need correct permissions for the account trying to run the maintenance jobs. check the owner in Maintenance Plan job - in SQL Agent jobs. Try using the "sa" just to check if it works with this user, then you can change to the user you need. This error usually occurs in Active Directory setup. Do you have it installed? Perhaps, your SQL Server service is running as a local account and it does not have domain access. Also check SQL Server Configuration Manager for SQL Server Agent account. Does it have necessary rights? Some answers are here: http://www.windows-tech.info/15/944bdabc733a57e3.php | ||||
|
feedback
|
|
The Maintenance Plans use the SQLAgent service to lookup the NT account info. If your on Vista or Windows7, personally, I would restart the SQL server running as the proper user account. Also, SP3 of SQL 2005 asks for you to explicitly define authority for certain user accounts as the admin of the SQL Server. If you didn't get that right then you might get problems with that. Did you put service pack 3 on your SQL 2005 yet? Here is a screenshot of it:
| |||
|
feedback
|
