VMware VS4-ENT-PL-A - vSphere Enterprise Plus, Setup Manual

Page: 33 / 276

8 Configure Microsoft SQL Server TCP/IP for JDBC on page 41
If the Microsoft SQL Server database has TCP/IP disabled and the dynamic ports are not set, the JDBC
connection remains closed. The closed connection causes the vCenter Server statistics to malfunction.
You can configure the server TCP/IP for JDBC.
9 (Optional) Configure a Microsoft SQL Server Database User to Enable Database Monitoring on
page 42
vCenter Server Database Monitoring captures metrics that enable the administrator to assess the status
and health of the database server. Enabling Database Monitoring helps the administrator prevent
vCenter downtime because of a lack of resources for the database server.
Create a SQL Server Database and User for vCenter Server
You must create a database and user for vCenter Server. To simplify the process, you can use a script.
In the script, you can customize the location of the data and log files.
The user that is created by this script is not subject to any security policy. Change the passwords as
appropriate.
Procedure
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 at
/<installation directory>/vCenter-
Server/dbschema/DB_and_schema_creation_scripts_MSSQL.txt
.
use [master]
go
CREATE DATABASE [VCDB] ON PRIMARY
(NAME = N'vcdb', FILENAME = N'C:\VCDB.mdf', SIZE = 3000KB, FILEGROWTH = 10% )
LOG ON
(NAME = N'vcdb_log', FILENAME = N'C:\VCDB.ldf', SIZE = 1000KB, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
go
use VCDB
go
sp_addlogin @loginame=[vpxuser], @passwd=N'vpxuser!0', @defdb='VCDB',
@deflanguage='us_english'
go
ALTER LOGIN [vpxuser] WITH CHECK_POLICY = OFF
go
CREATE USER [vpxuser] for LOGIN [vpxuser]
go
use MSDB
go
CREATE USER [vpxuser] for LOGIN [vpxuser]
go
You now have a Microsoft SQL Server database that you can use with vCenter Server.
What to do next
See “Set Database Permissions By Manually Creating Database Roles and the VMW Schema,” on page 34.
Chapter 3 Before You Install vCenter Server
VMware, Inc. 33