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

Configuring a domain controller


In a production environment, it is not recommended to install the domain controller with any of your other server software.

Note

Note that this section is optional. You do not need to configure a domain controller to start using the recipes in this book.

For development and testing purposes (such as ours), however, we will install them on the same machine. Should you want to mimic a production setup, you can create another Windows Server 2008 R2 VM with a different computer name, and follow the steps given:

  1. Launch VMWare Player.

  2. Play SQL2012 VM.

  3. Log in to our VM, KERRIGAN.

  4. Go to Administrative Tools | Server Manager.

  5. Click on Add roles. This will launch the Add Roles Wizard dialog.

  6. In the Select Server Roles screen, choose Active Directory Domain Services. This action will trigger the display of another window prompting if you want to install required features. Click on Add Required Features.

  7. Click on Next in the Introduction to Active Directory Domain Services window.

  8. Click on Next in the Confirm Installation Selections window.

  9. When done, view the results. Note that you will get a warning because we disabled automatic updates. For our purposes, this is acceptable.

  10. To configure the domain, go to Start and in the textbox type dcpromo and press Enter. This will start the Active Directory Domain Services Installation Wizard application.

  11. Click on Next on the wizard until you hit the Deployment Configuration window. Select Create a new domain in a new forest.

  12. In the Name the Forest Root Domain window, type queryworks.local in the FQDN of the forest root domain textbox.

  13. For Forest functional level, select Windows Server 2008 R2 and click on Next.

  14. In the Additional Domain Controller Options window, select DNS server as shown in the following screenshot:

  15. You will receive a warning about the computer having a dynamically assigned IP address. Click on Yes, the computer will use an IP address automatically assigned by a DHCP server. For our purposes, this is acceptable. Note that if this option is chosen, it is assumed that a DHCP server is already available on the network. Otherwise, the server will use an APIPA scheme, or Automatic Private IP Addressing, which does not work well with domain controllers.

  16. Another warning dialog will appear, informing you that delegation for the DNS server cannot be created. Click on Yes to continue.

  17. Accept the default folders for Location for database, log files, and SYSVOL.

  18. Type the password.

  19. Review the Summary of your selections.

  20. Finish the installation process of the wizard. When done, you will be prompted to restart as shown in the following screenshot:

  21. Once the Virtual Machine is back online, you will notice that the login screen no longer shows KERRIGAN\Administrator. It should now show QUERYWORKS\Administrator.

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