Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

20461C: Querying Microsoft® SQL Server® Microsoft Hyper-V® Classroom Setup Guid

20461C: Querying Microsoft® SQL Server® Microsoft Hyper-V® Classroom Setup Guide Contents Introducing Microsoft Hyper-V 1 Setup Overview 2 Classroom Requirements 2 Hardware 2 Software 3 Classroom Configuration 3 Instructor Computer Checklist 4 Instructor Computer Setup 5 1. Install the Hyper-V Server Role 6 2. Set Up the MSL-TMG1 Virtual Machine 7 3. Install the Virtual Machine Files 7 4. Create a Setup Share 9 5. Copy the Virtual Machine Files to the Student Computer 9 6. Run the VM-Pre-Import script 10 7. Import the Virtual Machines on the Instructor Computer 10 8. Configure the Virtual Machines on the Instructor Computer 10 9. Install the PowerPoint Slides 12 Student Computer Checklist 13 Student Computer Setup 14 1. Install the Hyper-V Server Role 14 2. Install the Base Image / Virtual Machine Files 14 Appendix A Keyboard Layout 15 Information in this document, including URL and other Internet Web site references, is subject to change without notice. Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, logo, person, place or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property. The names of manufacturers, products, or URLs are provided for informational purposes only and Microsoft makes no representations and warranties, either expressed, implied, or statutory, regarding these manufacturers or the use of the products with any Microsoft technologies. The inclusion of a manufacturer or product does not imply endorsement of Microsoft of the manufacturer or product. Links may be provided to third party sites. Such sites are not under the control of Microsoft and Microsoft is not responsible for the contents of any linked site or any link contained in a linked site, or any changes or updates to such sites. Microsoft is not responsible for webcasting or any other form of transmission received from any linked site. Microsoft is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement of Microsoft of the site or the products contained therein. © 2014 Microsoft Corporation. All rights reserved. Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners Product Number: 20461C 20461C: Querying Microsoft® SQL Server® 1 Introducing Microsoft Hyper-V Important Note: This setup requires Windows Server 2012 Hyper-V. To import virtual machines successfully to Windows Server 2012 Hyper-V you will have to run the VM-Pre- Import scripts which will create symbolic links to the Base/Middle-Tier images in the C:\Program Files\Microsoft Learning\20461\Drives\VirtualMachineName\Virtual Hard Disks\ folders. This learning product is designed using Microsoft® Hyper-V running on Windows Server 2012. Hyper-V is a virtualization technology that allows a single computer to act as a host for one or more virtual machines. The virtual machines use a set of virtual devices that might or might not map to the physical hardware of the host computer. The software that is installed onto the virtual machine is unmodified, full-version, retail software that operates exactly as it does when it is installed onto physical hardware. The following definitions will help you with the remainder of this document:  Hyper-V: Hyper-V is a server application that enables users to run a broad range of operating systems simultaneously on a single physical server.  Host Computer: The physical computer onto which an operating system and the Hyper-V server role have been installed.  Host Operating System: The operating system that is running on the physical computer. For this course, the only supported host operating system is Windows Server 2012.  Virtual Machine: The computer that is running inside Hyper-V. In this document, “Hyper-V” refers to the application running on the host, while “virtual machine” refers to the guest operating system and any software that is running inside the Hyper-V application.  Guest Operating System: The operating system that is running inside the virtual machine. Note: Pressing CTRL+ALT+DELETE while working with a virtual machine will display the Windows Security dialog box for the host operating system. To close the dialog box, press ESC. To access the Windows Security dialog box for a guest operating system, press CTRL+ALT+END. Other than this difference, software on a virtual machine behaves as it would behave on a physical computer. 2 20461C: Querying Microsoft® SQL Server® You can configure virtual machines to communicate with the host computer, other virtual machines on the same host computer, other host computers, virtual machines on other host computers, other physical computers on the network, or any combination thereof. The setup instructions that you will follow as part of this classroom setup guide configure Hyper-V and the Virtual Machines that run on the host. Changing any of the configuration settings may render the labs for this learning product unusable. Setup Overview The host computers must be set up with a 64 bit version of Windows Server 2012 and must be running on 64 bit hardware. For more information on the supported hardware for Hyper-V, please see the follow web site: http://www.microsoft.com/hyper-v. For the purposes of this learning product, it is not necessary for the host computers to be able to communicate with another network. However, allowing them to communicate with each other is recommended to make setup easier. The setup procedures below assume that the host computers can communicate with each other for setup purposes. You should note the administrator’s user name and password for the host computers and provide this information to the instructor. Classroom Requirements This learning product requires a classroom with a minimum of one computer for the instructor and one for each student. Before class begins, use the following information and instructions to install and configure all computers. Hardware The classroom computers require the following hardware and software configuration. Hardware Level 6+  Processor: Intel Virtualization Technology (Intel VT) or AMD Virtualization (AMD- V)  Hard Disk: Dual 120 GB hard disks 7200 RM SATA or better (Striped)  RAM: 8GB or higher. 16 GB or more is recommended for this course.  DVD/CD: DVD drive  Network adapter with Internet connectivity  Video Adapter/Monitor: 17-inch Super VGA (SVGA)  Microsoft Mouse or compatible pointing device  Sound card with amplified speakers 20461C: Querying Microsoft® SQL Server® 3 In addition, the instructor computer must be connected to a projection display device that supports SVGA 1024 x 768 pixels, 16 bit colors. Note: For the best classroom experience, a computer with solid state disks (SSDs) is recommended. For optimal performance, adapt the instructions below to install the 20461C-MIA-SQL virtual machine on a different physical disk than the other virtual machines to reduce disk contention. Software Please note that, unless otherwise indicated, this software is not included in the Trainer Materials disc. This learning product was developed and tested on supported Microsoft software, which is required for the classroom computers. Also required, but not included in the Training Materials: Microsoft Office PowerPoint® 2007 (instructor computer only). Classroom Configuration Each classroom computer will serve as the host for the following virtual machines that will run in Hyper-V. Domain or workgroup membership does not matter. The network configuration of the host computers should provide access to the Internet. After completion of the setup, all computers will be configured to run the virtual machines named:  MSL-TMG1  20461C-MIA-DC  20461C-MIA-SQL Estimated Time to Set up the Classroom: 90 Minutes Note: This course is designed to use an Internet connection inside the virtual machine. If there is no Internet connection present, this course will need to be modified to be delivered from a disconnected student machine. The Internet connection is required to access Microsoft Azure and Office 365, and the outbound internet connection must have TCP port 1433 open, otherwise Azure will not connect to the SQL instance in the VM. 4 20461C: Querying Microsoft® SQL Server® Instructor Computer Checklist  1. Install the Hyper-V Server Role.  2. Set Up the MSL-TMG1 Virtual Machine.  3. Install the Virtual Machine Files.  4. Create a Setup Share.  5. Copy the Virtual Machine Files to the Student Computer  6. Run the VM-Pre-Import script  7. Import the Virtual Machines on the Instructor Computer  8. Configure the Virtual Machines on the Instructor Computer  9. Install the PowerPoint Slides. (if needed) 20461C: Querying Microsoft® SQL uploads/Industriel/ 20461c-setup-guide 1 .pdf