Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
SQL Server 2012 with PowerShell V3 Cookbook

You're reading from   SQL Server 2012 with PowerShell V3 Cookbook

Arrow left icon
Product type Paperback
Published in Oct 2012
Publisher Packt
ISBN-13 9781849686464
Length 634 pages
Edition 1st Edition
Concepts
Arrow right icon
Author (1):
Arrow left icon
Donabel Santos Donabel Santos
Author Profile Icon Donabel Santos
Donabel Santos
Arrow right icon
View More author details
Toc

Table of Contents (21) Chapters Close

SQL Server 2012 with PowerShell V3 Cookbook
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
1. Getting Started with SQL Server and PowerShell FREE CHAPTER 2. SQL Server and PowerShell Basic Tasks 3. Basic Administration 4. Security 5. Advanced Administration 6. Backup and Restore 7. SQL Server Development 8. Business Intelligence 9. Helpful PowerShell Snippets SQL Server and PowerShell CheatSheet PowerShell Primer Resources Creating a SQL Server VM Index

Installing Windows Server 2008 R2 as Guest OS


To install the operating system, we first need to mount the Windows Server ISO and play the virtual machine. After that, we can follow the installation wizard.

  1. Launch VMWare Player. Go to Start | VMWare | VMWare Player.

  2. Select SQL2012VM and then select Edit virtual machine settings, as shown in the following screenshot:

  3. Let's increase the memory settings—adjust this based on your available hardware configurations. For our purposes we will increase memory to 2 GB (or 2048 MB), but you can definitely set this higher if you wish. Just make sure you have enough memory still left for your host OS, and other VMs that you may be running simultaneously.

  4. Select CD/DVD, and choose the Use ISO image file radio button. Navigate to Windows Server 2008 R2 ISO, and click on OK.

  5. Go back to the main VMWare Player screen and, while SQL2012VM is selected, click on Play Virtual Machine.

  6. Since we have mounted the ISO, the Windows Server installation screen will be displayed when the VM starts. Now we will need to follow the installation for Windows Server 2008 R2.

    For the installation language we will use English, and keyboard will be US.

    When prompted to install, select Install Now.

  7. When asked about the operating system to install we will choose Windows Server 2008 R2 Standard x64, but feel free to choose a different edition that you want to explore.

  8. Accept the license terms, and click on Next.

  9. When prompted for the type of installation, select Custom.

  10. In the Install Windows dialog, select Disk 0 Unallocated space.

  11. Let the installation complete. Note that the VM will be restarted a few times by the installation process.

  12. In one of the restarts you will be prompted to change the password.

    Provide the administrator password as shown in the following screenshot:

    When done, click on the arrow. This will log you in to your new VM.

  13. By default, the Initial Configuration Tasks screen will be displayed when you first log in.

  14. Under the Provide Computer Information section, click on Provide computer name and domain and set the following options:

    a. In the Computer description, type SQL2012 VM.

    b. Click on the Change button.

    c. In the Computer name textbox, type KERRIGAN.

    Click on OK, and then Apply. You will be prompted to restart the VM; choose Restart Later.

  15. Activate windows. Leave the Serial Number textbox blank, and click Activate.

  16. Restart the VM.

  17. We are almost ready. We just need to install the updates. Go to Start | Windows Update.

  18. Click on Let me choose my settings, the link below Turn on automatic updates. By doing this, we will disable automatic, ongoing updates for this VM.

  19. Under Important Updates, choose Never check for updates and click on OK.

  20. Click on check for updates and install all the critical and relevant updates. When asked to install Internet Explorer 9, install it.

  21. When prompted to restart, click on OK. Once the VM has restarted, log in using VM | Send Ctrl + Alt + Delete.

  22. Now let's disable the firewall. We are only doing this for our development VM. Go to Administrative Tools | Server Manager.

  23. Under the section Customize This Server go to Configure Windows Firewall and disable the firewall.

  24. On the left-hand side pane, select Turn Windows Firewall on or off.

  25. In the Customize Settings dialog, choose to turn off Windows firewall for both private and public networks.

  26. Now let's disable IE Enhanced Security Configuration. Go to Start | Administrative Tools | Server Manager.

  27. Under the Security Information section, click on Configure IE ESC located on the top-right box, as shown in the following screenshot:

  28. Select Off for both Administrators and Users. Click on OK.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image