Networks

Ask something
Question Locked

Maintenance Plan Error in SQL Server 2005

0 helpful
2 replies

by syedali1975

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All,
I have created a maintenance plan by using Login which Windows Domain NT Admin and SQL Server Admin as well.
Also in SQL Server 2005 the maintenance plan when set up schedule creates a SQL Server Agent job with same name by default. So the SQL Server Agent job which is created by the Maintenance plan showing the owner of the job the one with which I created the maintenance plan.
But the SQL Server agent job is failing with the error:

The job failed. Unable to determine if the owner (NT Login) of job Differential BackUps has server access (reason: Could not obtain information about Windows NT group/user 'NT Login', error code 0x5. [SQLSTATE 42000] (Error 15404)).

The previous DBA created couple of maintenance plan which are having there respective SQL Agent jobs which are running fine, so I found out that those jobs owner are ServerName\SQLService which is a user on the server and member of SQLSERVER2005SQLAgentUser$myservername$MSSQLSERVER.

I am wondering why my SQL Agent jobs fails when the login ID using windows authentication and member of Windows Domain, but not the other SQL Agent jobs which using same windows authentication.

Should the creator and owner of the Maintenance plan be member of SQLSERVER2005SQLAgentUser$myservername$MSSQLSERVER?

Please help me to resolve this issue?

Any comment, suggestions and fixes are well appreciated.

2 replies

by mike

If you're just trying to troubleshoot, try changing the owner of the SQL Server Agent Jobs to SA.

And you can find a couple other tips in the following Video (where it points out how to enable additional logging and troubleshooting options):
http://www.sqlservervideos.com/tsms

This discussion is closed to new replies.