Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Question Unanswered: Changed sa password, db maint plan not working

    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..:"

  2. #2
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •