You first create a database and user for vCenter Server. Then you assign permissions to the vCenter Server database user either by using the existing dbo schema and dbo_owner role or by creating custom database schema and roles.

Log in to the Microsoft SQL Server Management Studio as the sysadmin (SA) or a user account with sysadmin privileges.

The simplest way to assign permissions for a vCenter Server database user is through the database role db_owner.

As an alternative to using the db_owner database role, experienced database administrators can set permissions by creating database schema and roles manually, which ensures greater control over database permissions.