vCenter 5 new install questions (SQL related)

[mark_chuman]

Steps number 2, 3, 4 and 5 in the "Configure Microsoft SQL Server Databases" section of the "vSphere Installation and Setup - vSphere 5.0.pdf" are illustrated in the attached jpg.  I am of the opinion that you would perform either steps 2 and 5 or steps 3 and 4.  Any input on this?  Having a discussion with our SQL resource and her initial thoughts are that you would perform steps 2, 3, 4 and 5 to setup the database for vCenter 5.

Thanks for any input.

[Troy_Clavell]

basically all you need to do is create dbo permissions on the MSDC (to create rollup jobs) and dbo on the VCDB.  How you do that can be illustrated in the steps below. It's can be one or the other, but no need to do steps 1- 5

[mark_chuman]

Thanks.  I am curious about steps 2 and 5 because they are referred to as the "recommended" steps.  One benefit listed is that you no longer need to "elevate" permissions for install/upgrades, but other than that I don't see a big difference between those steps and 3 and 4.

[Troy_Clavell · Accepted solution]

steps 2 -5 are just different methods on how to create the permissions. They all really end up with the same resolve.

[sssstew]

Mark

I found this useful in my setup :-

http://www.boche.net/blog/index.php/2011/08/20/vcenter-server-5-0-and-ms-sql-database-permissions/

[mark_chuman]

My support tech at VMware also validated that the steps are separate.  Thank you for the feedback.