July 20, 2015 at 7:53 am
Has anyone experienced any difficulty with updates in the past week? One of our SQL servers (08R2) installed some updates and one of the databases stopped functioning until we went through and reset a service account PW. It's like a PW was reset and didn't cause issues until a later reboot. No one is fessing up though.
July 21, 2015 at 11:58 am
I haven't seen any update issues. But our corporate office is pretty strict on when these updates get pushed through (after thorough testing).
On the password side, though, there are some instances where things won't go into affect until a service is rebooted. I wonder if this is the case in your particular instance. Still, I would think a password should fail right away, unless the service isn't accessed often.
July 21, 2015 at 12:14 pm
I haven't heard of anything either. Then again, I'm slightly paranoid about system updates. Like Brandie, we only install updates after they've been tested on a development server.
July 21, 2015 at 9:00 pm
Thanks for the thoughts. Our servers no longer automatically install updates. I've seen it now twice on our new 2012r2 sql server - I had posted about that one last week - and am wondering if the fact that it's a domain account running the services that is the cause of the problem? I've had to go in and manually re-enter (the same) password in under services, log on.
July 22, 2015 at 4:43 am
jackfh (7/21/2015)
Thanks for the thoughts. Our servers no longer automatically install updates. I've seen it now twice on our new 2012r2 sql server - I had posted about that one last week - and am wondering if the fact that it's a domain account running the services that is the cause of the problem? I've had to go in and manually re-enter (the same) password in under services, log on.
If you don't have access to Active Directory, then engage someone who does. But make sure your domain account isn't set up to change passwords every 90 days. This is a default in AD and could be what is screwing up your services account.
July 22, 2015 at 3:51 pm
I thought that might be it but I would have to reset the PW if that policy was applying in this case and not be able to use the same one.
July 23, 2015 at 4:35 am
jackfh (7/22/2015)
I thought that might be it but I would have to reset the PW if that policy was applying in this case and not be able to use the same one.
Don't dismiss it immediately. It never hurts to double-check things like this so you can definitively rule them out.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply