October 12, 2020 at 5:41 pm
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
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
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...…"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply