Unable to create an Organization in vCloud Director

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:
When creating a new Organization you get the following error in the UI and out using MSSQL:

• JDBC rollback failed
• Invalid state, the Connection object is closed.

Cause

This issue occurs when the Database is not configured as per the vCloud Director Install Guide:
https://docs.vmware.com/en/vCloud-Director/9.1/com.vmware.vcloud.install.doc/GUID-C3C2E2DA-D760-413A-AA8A-A4BC674C068F.html

Resolution

1. Login into the SQL Management Studio where the vCloud Director database resides.
2. 'Right Click' on the database -> Properties

Note: By default the database name is 'vcloud'

3. 'Click' Options under 'Select a Page'
4. Change the following settings under the 'Miscellaneous' section:

                        Allow Snapshot Isolation: True
                        Is Read Committed Snapshot On: True