August 19, 2010 at 6:01 pm
When you change any SQL server service account on a server or cluster. The password is authenicated and the service continues to run. On a cluster, I recommend you Move (Fail OVER) the SQL Group to another node to confirm everything still works as designed.
We also change our SA passwords on all servers. Keep in mind you need to restart the SQL Service when you do. On a cluster you can change the SA password and then Move the SQL Group. Always verfiy that things still work.
You need to pay attention to the previous posts about maintenace jobs, we write SQL Jobs for backups and routine mainteance activity - they are less prone to the issue discussed.
August 20, 2010 at 11:24 am
bbaird_1945 (8/19/2010)
We also change our SA passwords on all servers. Keep in mind you need to restart the SQL Service when you do. On a cluster you can change the SA password and then Move the SQL Group. Always verfiy that things still work.
why?
---------------------------------------------------------------------
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply