In %ALLUSERSPROFILE%\VMWare\vCenterServer\log\vmware-vpx\vpxd.log file, you see entries similar to:
[42000](1934) [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'ANSI_NULLS, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. ERROR: Cannot execute statement(rc=-1). CREATE INDEX VPXI_EVENT_DVS_ID on VPX_EVENT (DVS_ID) WHERE DVS_ID IS NOT NULL;
ODBC error: (42000) - [Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Note: This log excerpt is an example. Date, time, and environmental variables may vary depending on your environment.
Environment
VMware vCenter Server 6.0.x
Cause
This is issue is caused by incorrect settings in the ODBC Driver configuration of the vCenter Server DSN.
Resolution
To resolve this issue:
Log in to the vCenter Server as an administrator.
Click on Start > Control Panel > Administrative Tools > Data Sources (ODBC).
Click the System DSN tab.
Edit the vCenter Server DSN.
Navigate through the wizard until you see the window with the option Use ANSI nulls, paddings and warnings.
Ensure that this option is checked and complete the wizard.