Is there a SQL query that can be run to find out the sa password.
I have sql maintenance plan in place for 5+ years and all of a sudden it doesn't work. The errors are basically:

'Status: Failed - Invoked on: 2005-08-02 08:30:00 - Message: The job failed. The owner () of job Transaction Log Backup Job for 'xxxxxxxxx Maintenance Plan' does not have server access.'

which is SQLSERVERAGENT Category: 3 Event #208

Any help would be greatly appreciated.

Hi,
This link may help u
http://support.microsoft.com/default...b;en-us;902388

koushikroy

Thanks for the link, however, I was able to delve deeper, and found the original Event Viewer error. The maintenance job was being run under a user ID. That user left the firm and the job was correctly reassigned to 'sa.'
There is a bug in SQL2000 specific to NT that specifies the 'repair any minor problems' under the Integrity Tab be unchecked.
When I unchecked this (it was checked) I was unable to stop the sqlserviceagent due to an error 5: access denied.
"An error 5 – (Access is denied) occurred while performing this service operation on the SQLServiceAgent service."

If you have any info on correcting this I'd have a very good weekend.