Pre-Creating the VMM Database
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Virtual Machine Manager, System Center 2012 R2 Virtual Machine Manager, System Center 2012 - Virtual Machine Manager
In some organizations, the system administrator that is installing Virtual Machine Manager (VMM) does not have the necessary permissions to create the database that is required by VMM. In this case, the VMM database needs to be created by an authorized administrator before the installation starts. Later, during Setup, you can point at this pre-created database. The VMM database needs to be pre-created as described below.
You can create SQL Scripts with the specified parameters, and then hand these scripts to the SQL administrators to ensure that the database is configured correctly.
How to pre-create the VMM database
Create a new database with the following settings:
Name: VirtualManagerDB
Collation: Latin1_General_100_CI_AS, but aligned with the specific SQL Server instance collation
Grant db_owner permissions for this database to the VMM service account
Run Setup to install VMM, and on the Database configuration page, select to use an existing database. Enter the details of the pre-created database.
Specify the VMM service account as the user for the database connection.