SQL Server 2012 PowerPivot Services: Service Account Keeps Getting Locked Out

Okay, I’ve had to call Helpdesk an embarrassing 8 times today because my PowerPivot upgrade is going horribly wrong and locking out my AD account that, admittedly, I use as a “service” account. I’m really left with no choice — I’m only granted one account on this network. Restrictive networks are so restrictive :|

For dev machines, I like to let PowerPivot setup my farm. Today, I was upgrading my SQL Server 2008 R2 instance to SQL Server 2012 and ultimately decided to just wipe out my entire 2008 instance and setup a new farm. Everything went well until the Validation area where it would say that my password isn’t valid. Here’s the workaround that worked for me:

  • Running the validation once (which always resulted in a lockout)
  • Unlocking the account
  • Entering my Service Account Password
  • Making the farm pass phrase the same thing
  • Validating once more. If it fails…
  • Type in the account password again but *click elsewhere* before hitting Validate so that the password box pretends it has additional characters.
  • Hit validate, party.

Chrissy is a PowerShell MVP who has worked in IT for nearly 20 years, and currently serves as a Sr. Database Engineer in Belgium. Always an avid scripter, she attended the Monad session at Microsoft’s Professional Developers Conference in Los Angeles back in 2005 and has worked and played with PowerShell ever since. Chrissy is currently pursuing an MS in Systems Engineering at Regis University and helps maintain RealCajunRecipes.com in her spare time. She holds a number of certifications, including those relating to SQL Server, SuSE Linux, SharePoint and network security. She recently became co-lead of the SQL PASS PowerShell Virtual Chapter. You can follow her on Twitter at @cl.

Posted in SharePoint, SQL Server

Leave a Reply

Your email address will not be published. Required fields are marked *

*