Error when running Maintenance Plan

Question

Error when running Maintenance Plan

db2l

Ten Centuries

Points: 1386
More actions
May 28, 2006 at 8:55 pm

#113202

Hi There,
I created a maintenance plan on my SQL Server 2000 instance, and tried to execute the job. It returned the following error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'SERVER1\MYSERVER as 'NT AUTHORITY\SYSTEM' (trusted)
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 229: [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'sysdbmaintplans', database 'msdb', owner 'dbo'.
I created the job under my NTDOMAIN userid which has system administrator access. The job is running under my ID, the SQL Server Agent is running under another NTDOMAIN userid that has system administrator access. But the "builtin\administrators" have their access removed.
My question is: why is the job running as NT AUTHORITY\SYSTEM and not my userid?
tks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Paul Mu SSCertifiable Points: 5547 More actions · Answer 1

By removing the BUILTIN\Administrators account from SQL Server, members of the [NT AUTHORITY\SYSTEM] workgroup account would no longer be able to access SQL Server unless explicitly granted. In other words, you will need to give sysadmin privileges to the account used for the SQL Server Agent Service.

db2l Ten Centuries Points: 1386 More actions · Answer 2

Thanks for your reply.

But as I mentioned, the account running SQL Server Agent has sysadmin privileges.

Ballack Cheng Soo How Old Hand Points: 362 More actions · Answer 3

May be you can try to explicitly grants NT\Authority system - sysadmin rights?

db2l Ten Centuries Points: 1386 More actions · Answer 4

Thanks, but I really just want to know why it is trying to run under this userid? Surely I can choose which userid to run the maintenance plan under? The userid I have chosen is a system administrator in this instance.