If you set database permissions by using the dbo schema and db_owner database role, you can use a script to create a vCenter Server user with the db_owner database role.

Alternatively, experienced database administrators can set permissions by creating database roles and the VMW and SQL Server database schemas. See Set Database Permissions By Manually Creating Database Roles and the VMW SchemaUse a Script to Create a Microsoft SQL Server Database Schema and Roles. That method, available beginning with vSphere 5.0, is recommended, because it gives the database administrator greater control over database permissions. That method removes the requirement to set up the database role dbo and db_owner schema for vCenter Server users who install and upgrade vCenter Server.

Create the vCenter Server database. See Create a SQL Server Database and User for vCenter Server

1

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

2

Run the following script.

The script is located in the vCenter Server installation package /installation directory/vCenter-Server/dbschema/DB_and_schema_creation_scripts_MSSQL.txt file.

use VCDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go
use MSDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go