Our in-house developer changed the "sa" password on the Sql 2000 server and now the database maintenance plan that I created for backups to disk isn't working.  The day it stopped I received the following errors in the log:
"2003-02-13 09:20:41.37 spid58    Error: 15457, Severity: 0, State: 1
2003-02-13 09:20:41.37 spid58    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2003-02-13 09:20:41.48 spid58    Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.
2003-02-13 15:54:25.59 spid53    Error: 15457, Severity: 0, State: 1
2003-02-13 15:54:25.59 spid53    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..:"I don't think that changing the sa password has got anything to do with the DBMaintenance plan unless you are using DTS for running the DB Backup etc etc.
 
No comments:
Post a Comment