Configuring SQL Server for vCenter

Continuing with our configuration of vCenter / Virtual Center and SQL Server 2005, its now time to configure the database.  Microsoft provides a free tool called SSMS (SQL Server Management Studio) to help manage SQL Server.  Download and install SSMS on the host you intend to install vCenter on.

In the following section, we will use SSMS to create a new database and set the appropriate permissions to allow vCenter to interface with SQL Server.  Lets begin!

1. Using SSMS, login to our newly created SQL Server instance
   
   
   
   
2. Create a new login for vCenter in order to access the database.  Expand the Security folder and right click on Login selecting the "New Login" option
   
   
   
   
3. Provide a login name and password for vCenter removing the "Enforce password expiration" option
   
   
   
   
4. On the Server Roles screen, select the "sysadmin" security privilege and click "OK"
   
   
   
   
5. From the Object explorer window, right click on the "Databases" folder and select "New Database"
   
   
   
   
6. On the New Database window, provide a name for the database and set the Owner to the user created from step #3 above
   
   
   
   
7. From the Options page, change the Recovery model to "Simple" and click "OK"
   
   
   
   
8. Locate the user created from step #3 above, and click properties
   
   
   
   
9. On the Login Properties window, change the users default database to the database created from step #6 above
   
   
   

Your SQL database is now configured for vCenter!  We will now continue with the configuration installing the SQL Native Client Driver on the vCenter host.

Comments

Add New Search

<< Begin < Prev 1 2 Next > End >> << Begin < Prev 1 2 Next > End >>

Anonymous |04/11/2009 08:06:43 thank you very much, it saved me ton of time. Reply | Quote

Anonymous |04/11/2009 09:47:51 Thanks for this. I stumbled across this from Google and as above was a great help Reply | Quote

Jess |04/12/2009 10:31:19 I wasn't finding a lot of info on vmware's site about SQL Server 2005. Thanks! Reply | Quote

Anonymous |09/12/2009 12:06:02 this is the best document i found. I just don't understand why vmware themself dont have something like that Reply | Quote

Dutchy |28/01/2010 06:39:53 This is indeed a great document. Thanks for taking the time to write this and make it available to the public. Reply | Quote

YOUR A ROCK STAR |02/03/2010 01:03:18 DUDE you should be a publisher, clear, direct, nice screens, XLNT Reply | Quote

Curt  - Question - Configuring VMware vCenter with SQL Ser |02/03/2010 11:14:52 Great job! Will this SQL setup also work with vCenter 4 ? Reply | Quote

Anonymous |08/04/2010 05:14:39 yes i have just installed vCenter4 accoding this tutorial Reply | Quote

Anonymous |03/04/2010 09:40:46 hi, VCenter Server Service will not start, can you help Reply | Quote

fred  - consultant |03/05/2010 04:27:17 Great job, thank you for sharing your knowledges ! Reply | Quote

Dyonisius Visser |21/07/2010 10:14:52 Hi, I;m trying to set up SQL Server 2008 ENterprise for use with Vcenter 4.1, do you have some docs available on that? Thanks. Reply | Quote

Daniel Martinez  - Great vCenter Setup Guide |30/07/2010 10:52:11 Excellent resource. I am going to refer my students to this site. Reply | Quote

Ravikumar |07/08/2010 17:01:12 Outstanding article and thanks a ton for posting this info, I have been searching for this guide for a while and finally landed in your blog. Thanks Again. Reply | Quote

Rob Z  - sys Ad |22/10/2010 07:20:16 Awesome Document thank you for the help it provided! Reply | Quote

Anonymous |21/12/2010 12:15:18 great man!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! i love you...... Reply | Quote

Anonymous |21/01/2011 03:18:19 Thanks for investing the time and effort; great explanations and screen shot examples! … The folks at VMware need to take notes, no doubt! "Love, Peace and Blessings" -- IPH Reply | Quote

Write comment
Name:
Email:	do not notifynotify
Website:
Title:
UBBCode:	-color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge
	Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."