Profile Driven Storage service fails to start after upgrading to vCenter Server 5.5

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• After upgrading vCenter Server to version 5.5, Storage views does not display.
• In the sps.log file located at C:\programdata\VMware\Infrastructure\Profile-Driven Storage\Logs\, you see entries similar to:
  
  <YYYY-MM-DD><time> [Thread-6] ERROR opId= com.vmware.vim.sms.provider.vc.VcProviderImpl - Failed populating service cache
  org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'domain\VC_machine_account$'.)
  at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
  at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
  at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
  at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:122)
  at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:99)
  at com.vmware.vim.sms.provider.vc.VcDataRetriever.retrieveVcDataFromDB(VcDataRetriever.java:59)
  at com.vmware.vim.sms.provider.vc.VcDataRetriever.retrieveData(VcDataRetriever.java:46)
  at com.vmware.vim.sms.provider.vc.VcProviderImpl.sync(VcProviderImpl.java:99)
  at com.vmware.vim.sms.ServiceImpl.syncServiceCache(ServiceImpl.java:386)
  at com.vmware.vim.sms.ServiceImpl.init(ServiceImpl.java:272)
  at com.vmware.vim.sms.ServiceImpl.access$100(ServiceImpl.java:60)
  at com.vmware.vim.sms.ServiceImpl$ServiceInitializer.run(ServiceImpl.java:160)
  Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'domain\VC_machine_account$'.
  
  
• The wrapper.log file contains message similar to
  
  INFO | jvm 1 |<YYYY-MM-DD><time></time> | ERROR opId= - Failed populating service cache
  INFO | jvm 1 |<YYYY-MM-DD><time></time> | org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'domain\VC_machine_account$'.)

 

Environment

VMware vCenter Server 5.5.x

Cause

This issue can occur when vCenter Server is using a remote database hosted on a Microsoft SQL Server with Windows Authentication, while the Profile Driven Storage service is configured to start with the local system account.

 

Note: If you are using Microsoft SQL Server 2012, BUILTIN\administrators and Local System (NT AUTHORITY\SYSTEM) are not automatically provisioned in the sysadmin fixed server role. This can prevent the Profile Driven Storage service from accessing the vCenter Server database. For more information, see the Security Enhancements (Database Enginer) section in the Microsoft SQL Server 2012 documentation.

Resolution

This is a known issue affecting vCenter Server.

Currently, there is no resolution.

To work around this issue, change the VMware vSphere Profile-Driven Storage Service account to a domain account that has permissions to access the vCenter Server database in SQL:

1. Click Start > Run, type services.msc, and click OK. The Services window opens.
2. Right-click the VMware vSphere Profile-Driven Storage service and click Properties.
3. Change Local system account to a domain user with SQL permissions.
4. Click OK.
5. Restart the VMware vSphere Profile-Driven Storage service.

Additional Information