vCenter / Virtual Center SQL Server 2005 Installation

We will begin our install with SQL Server 2005.  Managing the ESX hosts directly (with the VMware Infrastruce Client), we created a virtual machine that will be used for our SQL Server instance and loaded/patched it with Windows Server 2003 (not shown.)  We are now ready to begin installing SQL Server 2005 on this server:

1. From the SQL Server Installation screen, select the "Server components, tools, Book Online, and samples" option to being the install
   
   
   
   
2. Accept the End User License Agreement (EULA) and click "Next"
   
   
   
   
3. After the prerequisites have been meet, click "Next"
   
   
   
   
4. Click "Next" from the Welcome screen
   
   
   
   
5. Once the System Checks have completed, click "Next"
   
   
   
   
6. Enter the appropriate name and company information in the provided blanks and click "Next"
   
   
   
   
7. On the components install screen, select the "SQL Server Database Services" option and then click "Next"
   
   
   
   
8. Leave the instance name set to the default and click "Next"
   
   
   
   
9. Select the "Use the built-in System account" option leaving the Local system account selected.  Also select the "SQL Server" option to ensure SQL Server is started at the completion of installation.
   
   
   
   
10. Select "Mixed Mode" authentication and provide the 'sa' (SQL Administrator) password in the space provided.
    
    
    
    Note: SQL Server must be configured with SQL/local authentication.  vCenter does not support Windows authentication with SQL Server
    
    
11. Leave the defaults selected on the collation screen and click "Next"
    
    
    
    
12. Click "Next" on the Error and Usage reporting settings screen
    
    
    
    
13. Click "Install" to begin the installation
    
    
    
    
14. Click "Next" after all the components have been installed successfully
    
    
    
    
15. Click "Finish" to complete the installation
    
    
    
    
16. Open system services window
    
    
    
    
17. Locate the "SQL Server Agent" service.  Right click on the service name and select "Properties"
    
    
    
    
18. On the SQL Server Agent properties screen, ensure the Startup type is set to "Automatic" and the service is "Started"
    
    
    

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