An external Microsoft SQL Server database is required to be configured with the VMware Identity Manager service. To use the external database with VMware Identity Manager, your database administrator must prepare an empty Microsoft SQL Server database and schema before connecting to the database in VMware Identity Manager.
When you connect to the Microsoft SQL server, you enter the name of the instance ou want to connect to and the authentication mode. You can select either Windows Authentication mode and specify the domain\username or SQL Server Authentication mode and specify the local user name and password.
An internal Postgres SQL database is embedded in the VMware Identity Manager appliance, but the internal database is not recommended for use with production deployments.
You can connect to the external database connection when you run the VMware Identity Manager Setup wizard. You can also go to the Appliance Settings > VA Configuration > Database Connection Setup page to configure the connection to the external database.
Users can use Microsoft SQL Server to set up a high availability database environment.