Cloud Lab-7: How to install & Configure Microsoft SQL Server

LAB-7 TASKS

In this Lab we perform following tasks

  1. Create VM for Microsoft SQL Server
  2. Our Perquisites configuration for SQL Server
  3. Perquisites  for Microsoft SQL Server
  4. Install Microsoft SQL Server
  5. Basic SQL Server Settings

1.Create VM for Microsoft SQL Server

o   Right Click on Server and Choose New Virtual Machine
o   Enter VM Name (Cloud-SQL) and Inventory Location
o   Select Datastore
o   Select Virtual Machine Version: select latest available
o   Select “Microsoft Windows Server 2008 R2 (64-bit)” as OS Version
o   # of Virtual Processors: 1
o   Amount of RAM: 4GB
o   Network

  • # of NICs: 1
  • Adapter Type: VMXNET 3
  • Select “Connect at Power On

o   SCSI Controller: LSI Logic SAS
o   Create New Virtual Disk: 40GB
o   Use thin provision.
o   Install OS.

2.Our Prerequisite for Microsoft SQL Server VM

Before starting to install SQL Server. Configure following perquisite

  • Set system name (cloud-sql.vmlab.com)
  • Configure an IP address (192.168.150.3)
  • Enable remote desktop
  • Verify time and time zone settings (GMT+5) or whatever your time zone are.
  • Enter forward and Reverse DNS Entry for cloud-sql.vmlab.com 
  • Join SQL server to domain
  • Disable Windows Firewall

 Verify Settings after configuration

In the “Server Manager”, Verify the perquisite settings are correctly configured.

cloud-lab6-sqlinstall-1

 

3.Prerequisite for Microsoft SQL Server

Before starting to install SQL Server. Configure following perquisite

  • Create a service Windows account for vCenter database.
  • Control panel->Administrative Tools->Computer Management
  • In computer Management->Local User and Groups->Users->Right Click and Add Account.

cloud-lab6-sqlinstall-2

  • Securing Service account (deny service account to login to the local machine)
  • Control panel->Administrative Tools->Local Security Policy.

In local security policy->Local Policy->User Right Assignment->Deny Log on Locally->Add “sql_service” account.

cloud-lab6-sqlinstall-3

4.Install Microsoft SQL Server

Mount the SQL Server 2008 Enterprise DVD. Right Click on Setup->Run as administrator

cloud-lab6-sqlinstall-4

Installation->”New SQL Server Stand-alone Installation or add features an existing installation”

cloud-lab6-sqlinstall-5

Verifies that your system has no problems to proceed with the SQL Server installation. If the check reports any errors you should make sure to solve it before.

If all goes well then move forward-> Choose “OK”

cloud-lab6-sqlinstall-6

Enter the “SQL Server Product Key” or leave the first default option for trail period->Choose “Next”

cloud-lab6-sqlinstall-7

“Accept” License Agreement->click “Next”

cloud-lab6-sqlinstall-8

Click “Install”

cloud-lab6-sqlinstall-9

Again the setup runs some additional checks. Please note that if you didn´t turn off the Windows Firewall (and didn´t to any SQL specific customizations) you will get a warning for this rule. No reason to worry at this point, we can configure the firewall later. If you are running vCenter and the SQL Server on the same server, it isn´t necessary to do any changes on the firewall at all.

If everything is in green or yellow then -> click “Next” 

cloud-lab6-sqlinstall-10

Select the “highlighted features” for installation-> Click “Next”

cloud-lab6-sqlinstall-11

Leave everything as “default”, if this is your first SQL Server installation on the system -> Click “Next”

cloud-lab6-sqlinstall-12

Review the disk summary->Click “Next”

cloud-lab6-sqlinstall-13

Now we need to specify the user accounts and the startup type of the different services. Click the button “Use the same account…“

cloud-lab6-sqlinstall-14

Provide the user account (sql_service) credentials we created in the first step->Click “OK” 

cloud-lab6-sqlinstall-15

Before you click next you need to make sure the startup type of the SQL Server Agent is set to “Automatic”. On the other hand you should verify that it is set to “Disabled” for the SQL Server Browser.

Click “Next”

cloud-lab6-sqlinstall-16

The following window shows a very important step: The authentication security mode. I would strongly recommend you to use the “Windows Authenticate Mode”, if SQL and VCenter are on the same machine otherwise choose SQL Server authentication option and provide “sa” user password “P@ssw0rd”. You can now specify additional SQL Server administrators. Click on “Add Current User”. 

Click Next …

cloud-lab6-sqlinstall-17

Click “Next”

cloud-lab6-sqlinstall-18

Again Check the Rules, if everything is green. Click “Next”.

cloud-lab6-sqlinstall-19

Review settings-> Click “Install”

cloud-lab6-sqlinstall-20

Finally installation started.

cloud-lab6-sqlinstall-21

If everything goes well in installation process, then you will get following screen to acknowledge that SQL was installed successfully.

cloud-lab6-sqlinstall-22

5.Basic Microsoft SQL Server Settings

Go to SQL Server from Start menu ->Open the “SQL management studio

  • Add server name -> choose authentication as shown-> Enter username “sa” user credentials-> Click “connect”

cloud-lab6-sqlinstall-23

Object explorer-> right click-> properties

cloud-lab6-sqlinstall-24

Security Tab->Match you SQL settings with highlighted ones

cloud-lab6-sqlinstall-25

Memory Tab->Set Max RAM as highlighted (Define memory setting which SQL server will used), adjust as per need which you want SQL Server to use. Click “OK”.

cloud-lab6-sqlinstall-26

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

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