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.