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

Page: 36 / 276

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
/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
What to do next
“Configure a SQL Server ODBC Connection,” on page 40
Use a Script to Create a Microsoft SQL Server Database Schema and Roles
In this recommended method of configuring the SQL database, you create the custom schema VMW,
instead of using the existing dbo schema.
This method requires that you create new database roles and grant them to the database user. See
“Set
Database Permissions By Manually Creating Database Roles and the VMW Schema,” on page 34 and “Use a
Script to Create a Microsoft SQL Server Database Schema and Roles,” on page 36.
Prerequisites
Create the SQL Server database and user for vCenter Server. You can create the database manually or by
using a script. See “Create a SQL Server Database and User for vCenter Server,” on page 33
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
CREATE SCHEMA [VMW]
go
ALTER USER [vpxuser] WITH DEFAULT_SCHEMA =[VMW]
go
if not exists (SELECT name FROM sysusers WHERE issqlrole=1 AND name = 'VC_ADMIN_ROLE')
CREATE ROLE VC_ADMIN_ROLE;
GRANT ALTER ON SCHEMA :: [VMW] to VC_ADMIN_ROLE;
GRANT REFERENCES ON SCHEMA :: [VMW] to VC_ADMIN_ROLE;
GRANT INSERT ON SCHEMA :: [VMW] to VC_ADMIN_ROLE;
GRANT CREATE TABLE to VC_ADMIN_ROLE;
GRANT CREATE VIEW to VC_ADMIN_ROLE;
GRANT CREATE Procedure to VC_ADMIN_ROLE;
vSphere Installation and Setup
36 VMware, Inc.