Where can I find the step-by-step procedure for SQL DB in vCenter

[kappyninewood]

I need to create the SQL DB for vCenter in the SQL server itself, but I can't find good instructions pointing out the step-by-step instructions in SQL.

[weinstein5]

What are you looking to do - set up MS SQL for vCenter? What version of vCenter are you running? Are you looking to migrate you database?

For vSphere 5 here are the links to the approriate documentation -

For installing to SQL - http://pubs.vmware.com/vsphere-50/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-50-install...

For UPgrading or moving a database - http://pubs.vmware.com/vsphere-50/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-50-upgrade...

[kappyninewood]

Hi,  Im running vCenter 5.0 and I'm looking to setup a NET NEW environment.  New DB in SQL.

[Troy_Clavell]

page 176 of the install guide should get you started.  Beyond that, if you have questions about how to setup SQL and a DB instance, if you have a DBA in your company you may want to ask him/her

[sakibpavel]

Have a look...

http://www.tcpdump.com/kb/virtualization/vmware-esx-server/vcenter-howto/sql-server-config.html

Sakibpavel

[nava_thulasi39 · Accepted solution]

Hi,

This link may help to get understanding about SQL DB setup for vCenter

http://lonesysadmin.net/2011/10/06/how-to-install-microsoft-sql-server-2008-r2-for-vmware-vcenter-5/