Thought this may come handy for people who are planning for either an upgrade or migration from older version of vSphere to the latest 5.5, so sharing this scenario:
When you try to connect to vCenter using the vsphere client, you get the following:
The vCenter Server service is not running and will not start after the default restart attempts due to the vcenter_user account password has expired. In your vCenter Server, you may notice the following error in windows event viewer > Application logs:
Note: You can find the error logs in the vpxd.log as well.
Go (RDP) to your vCenter SQL database server, launch and login to the SQL Management Studio. Follow the below steps to uncheck the option Enforce Password Expiration.
- Browse to Security > Logins and select the account being used by the VirtualCenter Server service to connect to the vCenter database.
- Right-click the account and select Properties to view its Login Properties.
- Select the General page.
- Deselect Enforce password expiration. The password for the account is no longer expired.
- Exit from the SQL management utility.
- Start the VMware VirtualCenter Server service.
- Post correction, application log under Windows Event viewer should show the below messages:
Login succeeded for user 'vcenter_user'. Connection made using SQL Server authentication. [CLIENT: 127.0.0.1]
Reference VMWare KB article : 1012498