Michael Valentine Jones (4/2/2013)
Why would the service account get locked out? Are you using the same service account on more than one server?To answer your question, we setup new service accounts for each new server, generate a strong password (15+ characters with upper, lower, numbers and special characters), store the account and password info in a password safe (KeePass), set the new account to that password, and use that password during the installation.
I thought I was the only one who did this...
I also use KeePass to generate a 20 character strong password for the sa account. For those systems that I need to setup mixed-mode, I use that password during the installation.
Both the service account and sa account passwords are never shared with anyone - and the accounts are only used to run the services and setup SQL Server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs