How to Install SQL Server 2008 for your vSphere Home Lab


In this tutorial we will learn how to install SQL Server 2008 for our vSphere Lab. Many a times we will encounter the situation in our vSphere environment where we cant go with the installation of bundled SQL Express editions due to the limit imposed by this free edition. In that case we need to setup a separate database server where we can create database for our vCenter Server of can configure database instance for View Horizon.

Before proceeding with the installation check the hardware and software requirements from Here.

You can download SQL Server 2008 R2 from Microsoft Download

When you have ensured that your system meets all the hardware and software requirements, then its time to jump onto installation. Follow the steps shown below to install SQL Server 2008 R2 :

1: Navigate to directory where you have downloaded the installation files and Run the setup file.

sql1

2: Since this is a brand new install, choose “New Installation or add features to an existing installation”

sql2

A command prompt window will flash and Setup Rules dialog box will show up.

3: Make sure that all Setup Rules are passed. If there are failed rules, you won’t be able to proceed. In case of warnings, you can continue to install, but you still should note the warning and take corrective measures, before or after installation. Click on ok.

sql3

4: Type your product key and click on next

sql4

5: Go through the License Terms and if you are agrees upon the terms, then check on “I accept the license terms”. And then click on the “Next”.

sql5

6: Click on the “Install”.

sql6

7: Make sure that all Setup Rules are passed. If there are failed rules, you won’t be able to proceed. In case of warnings, you can continue to install, but you still should note the warning and take corrective measures, before or after installation.Click on Next button to proceed it further.

sql7

8: On Next screen select All features with default.

sql8

Under the Feature Selection, it’s on you what the feature you want to work with. You have the option to either Select All or multiple options can be selected. If you want to feature all of these features, then click on Select All. After this click on next

sql9

9: Select Default instance and click on next

sql10

10: Your system should surpass the requirements of space required by the installation process. Click on Next.

sql11

11: Sever Configuration page shows up the service accounts and collation configuration. In account name select NT Authority\system for all except SQL server integration service. For this select NT Authority\Network service.

sql12

12: On next screen, under account provisioning select mixed mode and set password for SA. After this click on add current user. You can add more user by clicking on add button.

sql13

13: On next screen select install the native mode default configuration and click on next.

sql14

14: On next screen leave both the check boxes unticked and Click on next.

sql15

15: click on next if all tests are passed

sql16

17: click on install button.

sql17

18: Installation will be started after clicking install. Now its time to sit and relax for a bit because installation takes some time.

sql18

sql19

19: With this our installation has finished.

sql20

About Alex Hunt

Hi All I am Manish Kumar Jha aka Alex Hunt. I am currently working in VMware Software India Pvt Ltd as Operations System Engineer (vCloud Air Operations). I have around 5 Years of IT experience and have exposure on VMware vSphere, vCloud Director, RHEL and modern data center technologies like Cisco UCS and Cisco Nexus 1000v and NSX. If you find any post informational to you please press like and share it across social media and leave your comments if you want to discuss further on any post. Disclaimer: All the information on this website is published in good faith and for general information purpose only. I don’t make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this blog is strictly at your own risk. The Views and opinions published on this blog are my own and not the opinions of my employer or any of the vendors of the product discussed.
This entry was posted in Vmware. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s