SQL 2005 Maintenance Cleanup Tasks never run

[jonalden2]

I have a DB maintenance plan for a SQL 2005 server that first runs full backups of all the DBs on the server.

The backups run everynight ok but the backups older than 5 days never delete. If I try to run the job manually i get the following error messages in the SQL Logs.

07/11/2008 11:04:11,,Error,[298] SQLServer Error: 3621<c/> The statement has been terminated. [SQLSTATE 01000] (ConnIsLoginSysAdmin),
07/11/2008 11:04:11,,Error,[298] SQLServer Error: 15404<c/> Could not obtain information about Windows NT group/user 'WHOST\whostadmin'<c/> error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

I have tried running the jobs using different accounts but the error message continues to happen... any suggestions?

Thanks,

Jon

 

[mrdenny]

For some reason the server isn't able to validate the owner of the job has rights to access the folder in order to delete the data.

Is the SQL Server running under a domain account or a local account?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jonalden2]

I believe the SQL Server service is running as a local account and I think the SQL agent is as well

 

[mrdenny]

Are any other jobs failing? It sounds to me like the SQL Server is having a problem authenticating with the domain. You might want to have your sysadmin check the logs on the domain controllers and see if there are any errors in there.

Are the backup files stored locally or on a remote server?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jonalden2]

they are being stored locally

 

[mrdenny]

I would definetly start with the domain controller sercurity logs and see if there are any failures in there. Are there any errors in the local security log?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog