SharePoint uses "Managed Accounts" which manage the AD accounts for you. SQL Server should have something similar for exactly this reason...

http://doitwithsharepoint.blogspot.com/2011/07/managed-accounts-in-sharepoint-2010.html

Basically, you can configure a SharePoint service (application...