On the Feature Selection page: Check Instance Features - Database Engine Services.
It should go without saying that you should talk to VMware or Microsoft Support if you are having issues.
I usually also select SQL Server Books Online, too, because I like having the reference available.As with all things in IT your mileage may vary, so use your head.I click the box in the Default Schema column for both msdb and vcdb, and set the default schema to dbo.Click the button Use the same account.and provide the user account credentials we created in the first step.I uncheck Enforce password policy, Enforce password expiration, and User must change password at next login.So thats a good time for to get a coffee or making a break .) On the end of the installation process you should hopefully see this screen:.) After you are done with the installation you should check your Windows Updates for some SQL.Disk requirements may be higher if the vCenter Server database runs on the same machine.Again, I set it to back up all databases, ignoring databases where the state is not online, and to back up to the same location as above (E:Program FilesMicrosoft SQL sqlservermssqlbackup) with the bak extension, expiring after 21 days.If everything is working click OK to close the odbc Data Source Administrator.15.) Now you get a short review of the disk space which is needed.After selecting the mode you need to enter a password for the sa user (system administrator).I like daily backups, too.If you are running vCenter and the SQL Server on the same server (maybe in small environments) it isnt necessary to do any changes on the firewall at all.One of the performance suggestions buried in the VMware KB is to regularly reorganize the indexes, since the historical statistics tables get unwieldy.They were probably obvious, and not taken from my work, but its content I dont need anymore.After the installation we can check the services if they are installed and started.On the Instance Configuration ms office 2007 professional page: I choose the default instance, leaving the instance ID set to the default (mssqlserver) and change the instance root directory from C: to E: with the same path.Product Interoperability Matrixes, to verify which version of the SQL Server is supported.Start the Microsoft SQL Server Management Studio again and log in as the sa user.
The Add Current User button is nice.