May 9, 2012 at 9:37 am
Hi,
one of our test server under sql agent + Maintenance plan some jobs are running daily under login : sa pwd :xyz as per the schedule under local account service
sqlversion 2005 enterprice edition.
now we have changed sa pwd xyz to abcd now all the jobs are failing.
my question is if you change sa password to new password do we need to change password for all jobs individually or sql server will take automatically the newly changed sa password
please clarify my question
May 9, 2012 at 11:11 pm
it will be get reflected automatically to all the area/section wherever used.
but haven't you hard coded rthe password anywhere ?
have you checked the job history for error ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 10, 2012 at 6:10 am
Is it the jobs that are failing or the agent is failing to start?
What login does the agent use to run?
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply