Thursday, December 1, 2011

vCenter 5: Prepare SQL Database

I was trying to find any article or videos or any help of steps or guide when I encounter setting up of the SQL database for vCenter 5.  I was surprise there wasn't much around.  The closest I got was from Jason Boche.

I mean if I were to just assigned DBO to both MSDN and the vCenter DB for the easy way out.  However as security and user rights has become a concern at many customers' requirement.  I tried going through the installation guide to setup database with just enough rights but no DBO.

The bad thing is its a lot of work to do it manually following the guide.  The good news is VMware has provided the script however some work need to be done to customize to your own needs.

Here my setup is on Windows 2008 R2 with SQL Server 2008 R2.

For MSDB, you can assign the DBO directly instead and remove it after installing vCenter and Update Manager.  Yes you hear me.  Do not remove the DBO rights on the vCenter user till you are done with Update Manager.  This is so as Update Manager installation also require access to MSDB.

You can definitely assign dbo to the vCenter database or just the required base on the script.

No comments:

VMUG Singapore VMC Session

With the launch of VMware Cloud (VMC) on AWS in Singapore back in April 2019, there has been lots of talk and questions. VMUG Singapore w...