Installing Microsoft SQL on Server 2012 R2

Resources:

Windows Server 2012 R2

Microsoft SQL 2012

Can be obtained from TCAT’s DreamSpark -

http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=5dee02e7-a65d-e111-8056-f04da23e67f6&vsro=8&JSEnabled=1

Note: you can use the trial software on Server and SQL if you do not have a Dreamspark account.

Files to use as demos:

http://msftdbprodsamples.codeplex.com/releases/view/55330

Virtualization needed:

http://www.vmware.com/products/player

Hardware needed:

Dual Core computer with 4 GB of RAM (Minimum)

How to:

Install VMWare Player and commit at least 30GB of HDD space, 1 CPU and 2 GB of ram (minimum).

Install Windows Server 2012 R2

Open Windows Server 2012 R2

Extract the SQL ISO into a folder on the Server

Click on Setup

Click on new SQL Server stand-alone installation

1 SQL

SQL Server 2012 Setup will run a Rule Check to make sure your computer is adequate 2 SQL

You should receive a pass for all items checked (.Net 2.0, .Net 3.5, etc.)3 SQL

Next enter your product key if applicable4 SQL

Click Next and accept the terms5 SQL

SQL Server will begin to install if you have corrected any items that may need correcting.7 SQL

This will check for Setup Support Rules.  Correct any failures if necessary.8 SQL

You will now select SQL Server Feature Installation9 SQL

On the next screen, it is recommended that you select all features if you are learning SQL10 SQL

This will in turn check the installation rules such as .Net Framework and Visual Studeio 2010.11 SQL

Create a default instance of SQL.  You can name the Instance ID or select a hard drive for the installation12 sQL

This will now check your space on the virtual machine (HDD space)13 SQL

It is recommended at the next screen to select the SQL Server agent be placed on automatic in the startup type14

Next select Mixed Mode and provide a complex password.  You will also add the Administrator or your account name as a SQL Server Administrator.15 SQL 16

Below is an example of a simple password.  You must use a complex password.17 SQL 18 SQL 19 20 21 22 23 24

Monitor your task manager and CPU to ensure you have adequate resources.25 26 Host 27

SQL Server manager will now be available for you to use.  While I installed this on my work laptop, you must remember to monitor laptops for heat and resource utilization.

Using one of the resources below, you can substitute what you learn on these pages and try writing queries from data you import from the codeplex database (http://msftdbprodsamples.codeplex.com/releases/view/55330).

A few links to SQL tutorials -

http://www.w3schools.com/sql/

http://www.sqlcourse.com/

http://www.1keydata.com/sql/sql.html

http://sqlzoo.net/wiki/Main_Page

Opening Studio

Opening Studio

Running a basic query

Sample Query

Server Manager – if you want desktop icons on Server, you must open the server manager and add a feature (Desktop Experience).

Features

If you right click on the desktop to use Personalize to add desktop icons, it will not be available.  You must use the above wizard to add features  (Desktop Experience to add icons such as Computer, Network, files and control panel).  Personalize will become available after a reboot.

Features 2Features 3

Export VMWare Player’s Virtual Machines to an OVF file

Need to move your VMWare or import it into VirtualBox?  In order to perform an export, download the ovftool from VMWare.  Install the software and after the installation-

  • Find the path to your VM
  • Open a command prompt (elevated).
  • Type CD\program files\vmware\vmware OVF_Tool
  • Enter
  • type ovftool “C:\the path to your VM\your VMname.vmx”  c:\new directory\name.ovf

 

Below you will see common syntax errors and the correct syntax at the bottom of the screenshot

 

ovf export

 

More information on the OVF Tool.

VMware Player Review – Virtualization that’s easy

VMware Player allows for the installation of a virtual machine onto your workstation.  This means of creating a second operating system within your operating system allows you to test or use an operating system of your choice.  The user-friendly interface is truly the easiest virtualization software there is.  Anyone wanting to try Windows 8 or any Linux distro can use this software to test operating systems.   VMWare Player can be downloaded here.

VMware Player is fully customizable and the wizard provides instructions that are well written and with easy to find settings.  Kudos to VMware for providing this excellent piece of software in an easy to use interface.

Remember, once you start the VM,  if you click the mouse in the window, it will take focus.  To release the mouse,  press Ctrl-Alt.

You must also remember to protect any OS in a VM.  (Antivirus information)

The first thing you will need is an .iso of your operating system of choice.

Win7iso

Above is the ISO for 32 bit Windows 7 with SP 1.

Next, install the VMWare Player.   The installation is straight forward and easy even for a novice.

1 vmplayer 2 vmplayer Two 3 vmplayer Three 4 vmplayer four 5 vmplayer five 6 vmplayer six 7 vmplayer seven 8 vmplayer eight

9 vmplayer nine

Now start the VMware Player by double clicking on the icon on your desktop.   In this scenario we created a new virtual machine.

10 vmplayer ten 11 VMplayer eleven

The New Virtual Machine Wizard walks you through step by step in setting up your operating system.

12 vmplayer 12 twelve

The wizard will ask for a location of the ISO or you can install from your DVD drive.  Select the appropriate location at this time (below).

13 vmplayer thirteen

Enter your product key and information if prompted to do so.  The Easy Install Information automates the installation process.  You can of course customize Windows and reset passwords, enable the Administrator account and change information once the operating system is installed.

14 vmwAREFOURTEEN

15 vmwarefifteen

Once the wizard reaches the customization stages for your hard drive, you can adjust this to meet your needs.

16 vmwaresixteen 17 vmwareseventeen

You can select the Customize Hardware button to adjust memory, processors and other hardware.   Remember to give your host machine plenty of memory.   Do not use more resources than you have.  This may cause lockups or other errors upon launching your OS.

18 vmwareeighteen

One of the best features is the Network Adapter Advanced Settings.  It allows you to bridge or NAT (Put your OS on a separate network – hidden from other computers on your network).  Bridging your network allows your virtual computer to be ‘seen’ by other computers as though it is a physical computer.   Because you are sharing a network card, you can limited the bandwidth (Inbound and Outbound traffic) of the virtual computer.

You can also generate a MAC address for the computer at this time.

The screenshot below (post install) shows the virtual computer when bridged (on the same network).

network

It is important to keep an eye on the resources of your host computer.  You can do this by using the Windows Task Manager.

20 vmplayer twenty

Once you finish, Windows will launch into setup mode.   You will see a message alerting you to other devices that can be used (Webcams and other devices) if they are available.

20 VMWaretwenty 21 vmplayer twenty one 21 VMWaretwentyone 25 VMplayer

As you can see from the screen shot below, the IP address is on the network with my other computers.  This allows the computer to share out documents and to utilize any device within the network.

26 vmplayer

The VMware player tools provides drivers and other features.

27 vmplayer tools

Installing the tools

30 VMware Tools 31 VMPlayer Tools Warning 32 VMWare Setting Up 33 VMWare Tools Setting up 34 VMWare Tools Setting Up 35 vmware custom settings 36 vmware tools setting up

40 vmware

Once the tools are installed, a restart should be made to the operating system.

Remember the option to use other devices during the setup – items such as the Webcam?  Click on Player when the VM starts and you will see the other devices.

Extra Stuff

You should also run a side by side comparison on the Task Manager’s to ‘see’ how much resources you are using.   As you can see, the host (left) is maxing out the memory of the host computer.   The virtual computer is not utilizing all of the allocated memory.   Therefore the 2Gb of RAM allocated can be tweaked by decreasing the memory if performance is not an issue.

Side by Side comparisons of resources

Once the VM is shutdown, you can adjust the settings in the console.

VMWare Complete

With dozens of tweaks and configurations, one of the best is the defragment, expansion and compact option under the hard disk in the virtual machine settings. (Compact only sorts the graintables but has no effect on size – optimizing your vm)

hard drive utilities

Overall VMware’s Player is an excellent tool that can be used (non-commercially) by anyone wanting to experiment with or run other operating systems.  VMware Player is an excellent virtualization tool that allows users to install and test or run another operating system.   The performance is based on shared resources of the host computer.  The ease of setup is definitely a pro.  Users should make every effort to ensure they have adequate resources on the host computer and the maximum amount of memory and other resources can be dedicated to the virtual machine.