VMware VS4-ENT-PL-A Setup Guide - Page 36

vSphere Installation and Setup 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/vCenterServer/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/vCenterServer/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; 36 VMware, Inc.