Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have created a maintenance plan but when I try to execute I get the error:

Message
[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'XX\Administrator', error code 0x534. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

I have given administrator db owner access but still get the error, what am I doing wrong?

share|improve this question

5 Answers 5

up vote 2 down vote accepted

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.

share|improve this answer

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

share|improve this answer

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: alt text

share|improve this answer

i had this problem and had to change the owner on the job to and sql account with the necessary permissions - > under SQL Agent > right click the job associated with your maintenance plan > Properties > Owner

If you later change the Maintenance plan the job owner changes back to your login so you have to go through this again.

share|improve this answer

I had the same problem . Maintaiance plan was giving me error . For this Go to SQL server Agent (Right Click) click on Jobs -> click on the relevent sub plan - > change the owner of the database to [sa]. and now execute the maintainance plan

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.