Creating a ODBC Connection for vCenter

Now that we have the SQL Native Client Driver installed on the vCenter server, we now need to configure a system DNS entry for vCenter to use:

1. Open the Control Panel
   
   
   
   
2. Open Administrative Tools
   
   
   
   
3. Open Data Sources (ODBC)
   
   
   
   
4. Click the System DSN tab and click the "Add" button
   
   
   
   
5. Select the "SQL Native Client" driver and click "Finish"
   
   
   
   
6. Provide a Name for the driver (you will reference this name during the vCenter install) and provide the hostname/IP of the SQL Server instance you created in the previous section in the Server field
   
   
   
   
7. Select the "SQL Server authentication" type and provide the login and password created from the "Configuring SQL Server for vCenter" section
   
   
   
   
8. Change the default database to the database created in the "Configuring SQL Server for vCenter" section
   
   
   
   
9. Click "Finish" to complete the setup
   
   
   
   
10. Click the "Test Data Source" button to validate the settings you provided
    
    
    
    
11. Assuming the test completed successfully, click the "OK" button
    
    
    
    
12. Click "OK" to complete the test
    
    
    
    
13. Confirm the DSN is present and click "OK"
    
    

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."