Installing vRealize Automation 7.x when configuring the IaaS SQL database fails

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Symptoms:

• Installing vRealize Automation when configuring the IaaS SQL database fails.
• You see the error:
  
  EXEC sp_executeSQL @Query: SELECT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct

Environment

VMware vRealize Automation 7.x

Cause

This issue occurs because server level triggers used for audit purposes on SQL-Server interfere with the database creation process.

Resolution

This is a known issue affecting vRealize Automation 7.x.

Currently, there is no resolution.

Workaround:
To work around this issue, disable server-level triggers and retry install/upgrade.