VMware VS4-ENT-PL-A Setup Guide - Page 32
Maintaining a vCenter Server Database, Con Microsoft SQL Server Databases - 6 documentation
View all VMware VS4-ENT-PL-A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 32 highlights
vSphere Installation and Setup 2 Ping the computer name to test this connection. For example, if the computer name is host-1.company.com, run the following command in the Windows command prompt: ping host-1.company.com If you can ping the computer name, the name is updated in DNS. Maintaining a vCenter Server Database After your vCenter Server database instance and vCenter Server are installed and operational, perform standard database maintenance processes. The standard database maintenance processes include the following: n Monitoring the growth of the log file and compacting the database log file, as needed. n Scheduling regular backups of the database. n Backing up the database before any vCenter Server upgrade. See your database vendor's documentation for specific maintenance procedures and support. Configure Microsoft SQL Server Databases To use a Microsoft SQL database for your vCenter Server repository, configure your database to work with vCenter Server. Procedure 1 Create a SQL Server Database and User for vCenter Server on page 33 You must create a database and user for vCenter Server. To simplify the process, you can use a script. 2 Set Database Permissions By Manually Creating Database Roles and the VMW Schema on page 34 By using this recommended method, available with vCenter Server 5.x, the vCenter Server database administrator can set permissions for vCenter Server users and administrators to be granted through Microsoft SQL Server database roles. 3 Set Database Permissions by Using the dbo Schema and the db_owner Database Role on page 35 If you use Microsoft SQL Server database, the simplest way to assign permissions for a vCenter Server database user is through the database role db_owner. Assign the db_owner role to the vCenter Server database user on both the vCenter and MSDB databases. 4 Use a Script to Create a vCenter Server User by Using the dbo Schema and db_owner Database Role on page 35 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. 5 Use a Script to Create a Microsoft SQL Server Database Schema and Roles on page 36 In this recommended method of configuring the SQL database, you create the custom schema VMW, instead of using the existing dbo schema. 6 (Optional) Use a Script to Create Microsoft SQL Server Database Objects Manually on page 37 You can create database objects manually with this method of configuring the SQL database. 7 Configure a SQL Server ODBC Connection on page 40 After you create a vCenter Server user, establish a connection with a SQL Server database. This connection is required to install a vCenter Server system. 32 VMware, Inc.