Build your own SQL 2012 Demo Machine – Part 3 – Installing and Configuring Windows Server 2008R2

Step 4: Install Windows Server 2008R2

If you are following from Step 2, Windows Server 2008R2 should be installing, and you just need to wait for thsi first dialog to appear.

1: Set your locale options

Fig 4.1: Set your locale preferences

Fig 4.1: Set your locale preferences

The only thing I’ve changed from default is to change my time and currency to Australia, as that’s where I am. Then I clicked Next.

2: Install – go on – click it!

Fig 4.2: Install Now

Fig 4.2: Install Now

 

3: Choose the version to Install. We want Enterprise (Full Installation):

Fig 4.3: Choose Install Version

Fig 4.3: Choose Install Version

Click Next, then on the next screen accept the licensing terms.

4: Do a Custom Installation:

Fig 4.4: Choose Installation Type

Fig 4.4: Choose Installation Type

I’ve no idea why there isn’t simply a “New Install” option.

5: Specify Install location – use the fixed disk we created earlier

Fig 4.5: Choose Install Location

Fig 4.5: Choose Install Location

Click Next and go have a break. This bit takes a while. Eventually…

6: Set the Administrator password:

Fig 4.6: Change the Administrator Password

Fig 4.6: Change the Administrator Password

Fig 4.7: Change the Administrator Password

Fig 4.7: Change the Administrator Password

Fig 4.8: Change the Administrator Password

Fig 4.8: Change the Administrator Password

7: The Server will now log you in and you can start configuring. At this point I start recommending taking snapshots of the VM – save points in case you need to roll back and restart from a certain point. From the Oracle VirtualBox manager, click on the snapshot button to view available snapshots:

Fig 4.9: View available snapshots

Fig 4.9: View available snapshots

8. Click on the photo icon to take a snapshot

Fig 4.10: Take a snapshot

Fig 4.10: Take a snapshot

Name it

9. Click OK. From now on any further activity will be building on this snapshot.

Fig 4.11: Name the snapshot

Fig 4.11: Name the snapshot

 

10: Back to configuring Windows. There’s a bundle of things to do, so we’ll do them in batches. From the Initial Configuration screen, we need to activate Windows and Automatic Updates:

Fig 4.12: Initial Configuration Tasks

Fig 4.12: Initial Configuration Tasks

Activation is straightforward – just click on the link and enter your product key.

For Updates, just turn on automatic updates. It’ll go through a check and install a bunch of updates. This can be a bit slow and painful but will lead to a more stable build. You may get a few prompts, just OK everything you want in the build, and there inevitably will be restarts involved. It will prompt for the installation of Internet Explorer 9 – OK this – it is supported for PowerView and SSRS. Once you have downloaded, installed and restarted enough times that Windows Update goes silent, we can move on to the next stage.

11: Turn your server into a Domain Controller. This is required for SharePoint 2010′s BI features. These steps are as per this guide from Clement DeLarge, but repeated for your benefit below.

12. From the Server Manager click “Roles” then “Add Roles”

Fig 4.13: Add a Server Role

Fig 4.13: Add a Server Role

A “Before You Begin” dialog will pop up, just click next as there’s no actions here.

13. Next choose to add the “Active Directory Domain Services” Role:

Fig 4.14: Add the Active Directory Domain Services Role

Fig 4.14: Add the Active Directory Domain Services Role

This will launch a prompt to add the required .Net Framework 3.5.1 Required features (this is also needed by SharePoint and SQL on their own) -

14. Click on the “Add Required Features” button.

Fig 4.15 Add Required Feature .Net Framework 3.5.1

Fig 4.15 Add Required Feature .Net Framework 3.5.1

This window will then close and you’ll be back to the screen shown in Fig 4.14 but with the checkbox for Active Directory Domain Services (AD DS) now checked.

15. Click Next. This brings you to the AD DS overview screen. Read it if you want

16. Click Next. This is the installation confirmation screen.

Fig 4.16: Installation Confirmation Screen

Fig 4.16: Installation Confirmation Screen

17. Choose Install, and the installation process will run through. Once completed you will get an option to close where the Install button was in the above screenshot.

18.Click it. This will then return you to the Server Manager, which will indicate an issue with AD DS.

Fig 4.17: Active Directory Domain Services Warning

Fig 4.17: Active Directory Domain Services Warning

19. Click the warning. It will lead you to the summary screen which warns you you are not yet running AD DS and you need to run a Wizard.

Fig 4.18: Active Directory Domain Services Warning

Fig 4.18: Active Directory Domain Services Warning

20. Click the link to launch the wizard.

Fig 4.19: Active Directory Domain Services Installation Wizard

Fig 4.19: Active Directory Domain Services Installation Wizard

21. Click Next. A warning screen comes up about compatibility with other OSes which we can ignore as this is a standalone machine. Click next to choose the .Deployment Configuration.

Fig 4.20: AD DS Deployment Configuration

Fig 4.20: AD DS Deployment Configuration

22. This is a new, standalone machine so choose “Create a new domain in a new forest”

23. Click next. This will lead you to to name your new forest.

Fig 4.21: Name the Forest Root Domain

Fig 4.21: Name the Forest Root Domain

I’ve been fairly unimaginative here and just called it SQL2012.net (it needs to be something.something). Feel free to call it whatever you like, then

24. Click Next. It will then run through some checks to make sure the name is OK.

The next dialog is to select the Forest Functional Level.

Fig 4.22: Select the Forest Functional Level

Fig 4.22: Select the Forest Functional Level

25. Once again, as this is a Standalone machine we can not worry about backward compatibility and select “Windows Server 2008R2″

26. Click Next. Again it will run through some checks then bring you to the next dialog, “Additional Domain Controller Options”.

Fig 4.23: Additional Domain Controller Options

Fig 4.23: Additional Domain Controller Options

Leave the DNS Server checkbox ticked and

27. Click Next. You may now see a warning about Static IP Assignment.

Fig 4.24: Static IP warning

Fig 4.24: Static IP warning

28. Choose No – It only really matters on a real Domain Controller, but static IP’s will help avoid any networking confusion down the line.The dialog will close.

29. Go to the Control Panel, and choose Network and Internet, then Network and Sharing Center, and finally Change Adapter Settings, which will lead you to a display of available adapters (there should be only one):

Fig 4.25: Network Adapters

Fig 4.25: Network Adapters

Right click and choose properties to get the following dialog:

Fig 4.26: Network Adapter Properties

Fig 4.26: Network Adapter Properties

30. In the above dialog, uncheck “Internet Protocol Version 6 (TCP/IPv6).

31. As indicated above, select “Internet Protocol Version 4 (TCP/IPv4)” and click the Properties button to get a dialog like this:

Fig 4.27: IPv4 Properties

Fig 4.27: IPv4 Properties

DO NOT COPY THESE NUMBERS. They are machine specific and can be found by the following:

32. Run the command prompt and enter the command ipconfig /all. Find the active Ethernet adapter:

Fig 4.28: Guest Ethernet Adapter IP properties

Fig 4.28: Guest Ethernet Adapter IP properties

Not taking my word as gospel , you then enter the following based on the default gateway as AAA.BBB.CCC.DDD:

IP Address = AAA.BBB.CCC.(DDD+20)

Subnet Mask: 255.255.255.0

Default Gateway: AAA.BBB.CCC.DDD

DNS Servers are a little trickier. I found that I needed to set them to the DNS servers of the host.

33. So I had to run ipconfig on the host and use those DNS servers addresses:

Fig 4.29: Host IP Configuration

Fig 4.29: Host IP Configuration

I then filled the Preferred DNS Server and the Alternate DNS Server with the numbers in the yellow boxes. Note that whenever your machine changes network, you will need to change these numbers. And sometimes, on corporate networks, you just won’t be able to get a working internet connection. VirtualBox is a bit flaky in this regard, it appears.

If none of this works, switch back to the default “Obtain Automatically” options… and phone a friend. No, another friend… I don’t do networks and would never have worked this out without the help of a colleague.

34. Click OK on the dialog in Fig 4.27, and Close on the dialog in Fig 4.26.

Return to the dialog in Fig 4.23 and click Next.

It will run through some checks again, then throw up this warning:

Fig 4.30: Parent Zone Warning

Fig 4.30: Parent Zone Warning

35. Click Yes to continue, there us no Parent Zone for us to worry about. The next dialog specifies default storage paths.

Fig 4.31: Storage Paths

Fig 4.31: Storage Paths

36. Leave these untouched and click Next. You now need to set a Restore Mode password.

Fig 4.32: Restore Mode Administrator Password

Fig 4.32: Restore Mode Administrator Password

37. I just reused my Administrator password as this isn’t a production machine. Finally you get to a summary screen. Review your settings.

Fig 4.33: AD DS Summary Screen

Fig 4.33: AD DS Summary Screen

38. Click Next and the configuration process begins. Once it’s completed you’ll see this screen:

Fig 4.34: AD DS Wizard Finish screen

Fig 4.34: AD DS Wizard Finish screen

39. Restart, install any new updates and restart again if required.

Some browser tweaking needs to be done – we need to disable Internet Explorer Enhanced Security Configuration so we can actually use the browser, and install Silverlight so PowerView will work.

40. From Server Manager, locate the Security Information section and find the link to configure IE ESC:

Fig 4.35: Configure Internet Explorer Enhanced Security Configuration

Fig 4.35: Configure Internet Explorer Enhanced Security Configuration

41. Click it and this dialog pops up:

Fig 4.36: Configure Internet Explorer Enhanced Security Configuration

Fig 4.36: Configure Internet Explorer Enhanced Security Configuration

42. Turn IE ESC off for Administrators and Users and click OK.

43. Next, Install Silverlight. Open up IE and go here: http://www.microsoft.com/getsilverlight/Get-Started/Install/Default.aspx. Click the big install button and follow instructions to install it.

44. Finally, run Windows Update, download and install any updates found and restart. Then our OS setup is complete and we are ready for the first 2 installations of SQL Server!

45. Move on to Build your own SQL 2012 Demo Machine – Part 4 – Installing SQL Server twice

About BI Monkey

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!