VMware VS4-ENT-PL-A Setup Guide - Page 37
Use a Script to Create Microsoft SQL Server Database Objects Manually
View all VMware VS4-ENT-PL-A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 37 highlights
Chapter 3 Before You Install vCenter Server if not exists (SELECT name FROM sysusers WHERE issqlrole=1 AND name = 'VC_USER_ROLE') CREATE ROLE VC_USER_ROLE go GRANT SELECT ON SCHEMA :: [VMW] to VC_USER_ROLE go GRANT INSERT ON SCHEMA :: [VMW] to VC_USER_ROLE go GRANT DELETE ON SCHEMA :: [VMW] to VC_USER_ROLE go GRANT UPDATE ON SCHEMA :: [VMW] to VC_USER_ROLE go GRANT EXECUTE ON SCHEMA :: [VMW] to VC_USER_ROLE go sp_addrolemember VC_USER_ROLE , [vpxuser] go sp_addrolemember VC_ADMIN_ROLE , [vpxuser] go use MSDB go if not exists (SELECT name FROM sysusers WHERE issqlrole=1 AND name = 'VC_ADMIN_ROLE') CREATE ROLE VC_ADMIN_ROLE; go GRANT SELECT on msdb.dbo.syscategories to VC_ADMIN_ROLE go GRANT SELECT on msdb.dbo.sysjobsteps to VC_ADMIN_ROLE go GRANT SELECT ON msdb.dbo.sysjobs to VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_add_job TO VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_delete_job TO VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_update_job TO VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO VC_ADMIN_ROLE go GRANT EXECUTE ON msdb.dbo.sp_add_category TO VC_ADMIN_ROLE go sp_addrolemember VC_ADMIN_ROLE , [vpxuser] go (Optional) Use a Script to Create Microsoft SQL Server Database Objects Manually You can create database objects manually with this method of configuring the SQL database. Alternatively, you can configure a SQL Server ODBC connection and run the Install package. The vCenter Server installer will create database objects. See"Configure a SQL Server ODBC Connection," on page 40. Using a script to create database objects manually requires that you take one of the following actions. n Grant the db_owner role to the database user in VCDB and in MSDB. See "Set Database Permissions by Using the dbo Schema and the db_owner Database Role," on page 35 and "Use a Script to Create a vCenter Server User by Using the dbo Schema and db_owner Database Role," on page 35. VMware, Inc. 37