Appendix B. Creating a SQL Server VM

In this appendix, we will cover the following topics:

  • Terminologies
  • Downloading software
  • VM details and accounts
  • Creating an empty virtual machine
  • Installing Windows Server 2012 R2 as a guest OS
  • Installing VMWare tools
  • Configuring a domain controller (optional)
  • Creating domain accounts
  • Installing SQL Server 2014 on a VM
  • Configuring Reporting Services in native mode
  • Installing sample databases
  • Installing PowerShell V5

Introduction

One of the best ways to learn and understand SQL Server and the components that interact with it is by creating a virtual machine that has the version of SQL Server you want to use. I typically use SQL Server virtual machines for my development and administration classes. I want the students to ...

Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.