Post reply

Maint Plan Failing after 'sa' Disabled

  • October 12, 2020 at 5:41 pm

    #3796440

    I have 4 Maint Plans, 1 of which fails because 'sa' is disabled, but I don't see 'sa' specified in the plan. It rebuilds indexes, updates statistics, deletes old backups, then takes new backups.

    The other 3 Maint Plans just run DIFFS and T-Log backups.

    All 4 Scheduled Job Owners are a Windows account.

    On each Maint Plan step, the "Connection" is "Local Server Connection", including the 3 successful jobs.

    What am I missing ?

  • October 12, 2020 at 6:05 pm

    #3796441

    A couple of places to check - in the job, edit the step that executes the package and check the Package tab where the login can be specified and on the Data Sources tab check the entire connection string for the connection manager.

    Sue

  • October 12, 2020 at 6:12 pm

    #3796442

    THANKS ! Not sure how 'sa' got in the connection string for that 1 job.

    ".....on the Data Sources tab check the entire connection string for the connection manager...…"

    • This reply was modified 4 years, 2 months ago by  homebrew01.
    • This reply was modified 4 years, 2 months ago by  homebrew01.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply