6.7

4 Configure Microsoft SQL Server TCP/IP for JDBC
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.
Prepare the vCenter Server SQL Server Database
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.
Prerequisites
Log in to the Microsoft SQL Server Management Studio as the sysadmin (SA) or a user account with
sysadmin privileges.
Prepare the vCenter Server Database by Using the dbo Schema and the db_owner Database
Role
The simplest way to assign permissions for a vCenter Server database user is through the database role
db_owner.
You must first create a database and user for vCenter Server. Then you can use the existing dbo_owner
database role and let the vCenter Server installer create the default dbo schema that assigns database
user permissions to that role. You must also enable database monitoring for the user before you install
vCenter Server. See Database Permission Requirements for vCenter Server.
To perform the following procedure, you can either use the graphical user interface or run scripts. The
vCenter Server installer package contains example scripts in the vCenter-
Server\dbschema\DB_and_schema_creation_scripts_PostgreSQL.txt file.
Procedure
1 Create a database and user for vCenter Server.
a In the master database, create a database for vCenter Server.
b Create a database user for vCenter Server and map it to the vCenter Server and msdb
databases.
For example, to create the database VCDB and user vpxuser, you can run the following script:
use master
go
CREATE DATABASE VCDB ON PRIMARY
(NAME = N'vcdb', FILENAME = N'C:\database_path\VCDB.mdf', SIZE = 10MB, FILEGROWTH = 10% )
LOG ON
(NAME = N'vcdb_log', FILENAME = N'C:\database_path\VCDB.ldf', SIZE = 1000KB, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
go
use VCDB
go
CREATE LOGIN vpxuser WITH PASSWORD=N'vpxuser!0', DEFAULT_DATABASE=VCDB,
DEFAULT_LANGUAGE=us_english, CHECK_POLICY=OFF
vCenter Server Installation and Setup
VMware, Inc. 92