03. Setup SQL Server for TFS - Setup Virtual Environment for TFS 2013 - Using Virtualbox

This is the third step of Setup Virtual Environment for TFS 2013 - Using Virtualbox. In this step I will explain setup SQL Server instance with reporting services for Installing TFS Server 2013 - Single Server Deployment (since the limited RAM available for me I cannot set up many machines in my laptop ).

I have explained setting up a domain controller and VM for TFS in the isolated domain in previous two posts of this series. 

Before installing SQL Server  for TFS we need to setup a service account to run SQL server. Having a domain account as the SQL Server service account is not a requirement for TFS server. We can use a built in system account. But I prefer a domain account.

We are going to do below three main steps here.

 a) Install SQL 2012

 b) Install SQL 2012 SP1

 c) Install  Cumulative Update 2 for SQL 2012 SP1. (TFS Installation guide says "If you're using SQL Server 2012 with SP1, we recommend you also apply cumulative update 2 on top of SP1 to address a critical SQL Server bug around resource consumption.")

Set up SQL 2012

01. Go to the PDC we have setup in the first step and add an account for SQL Server as shown below.

02. Next go to the VM for TFS and Web Server(IIS) role service.

Install ASP.Net role service as well.

03. Now shut down the TFS VM. To enable internet access to TFS VM (currently only isolated internal network enabled) add a second network adapter and setup it in NAT mode. For more information about different network options with virtual box refer here.

04. Start TFS VM and run SQL Server 2012 server setup (since we are going to setup Sharepoint Foundation 2013 in this machine we need to install SQL Server 2012 bit edition 64  or SQL Server 2008 R2 Service Pack 1 64 bit edition). Run system configuration checker.

05. Start setting up new instance.

06. We need only below features.

07. Set the SQL server service accounts as below.

08. Collation configuration

09. Add current user. In my case TFS Administrator domain account.

10. Set reporting services to install and configure.

11. Start installation

12. We are done with installation.

13. Reboot the TFS VM.



SQL Server SP1

01. Download SQL 2012 SP1(SQLServer2012SP1-KB2674319-x64-ENU.exe) and  start installtion.

02. Reboot the TFS VM.



Cumulative Update 2 for SQL Server 2012 SP1

(SQLServer2012_SP1_CU2_2790947_11_0_3339_x64) get this file from the email link in MS support site.

01. Run the installation.

02. Reboot the TFS VM.

Now we have installed and configure SQL Server 2012 SP1 with reporting services ready for our TFS server. Next step is to set up SharePoint Foundation 2013.

.Net Forum - Sri Lanaka Jan. 2014 Session - Build-Deploy-Test Part 2 - Unit Tests & Automation with TFS Builds

Done the second part of Build-Deploy-Test Automation session series @ Sri Lanka . Net Forum on 02 January 2014. Awesome start to the year for me with, receiving the precious award of MVP for ALM.

For the folks asked for the slides and the sample code I used at the session, download them from the below links.

Build-Deploy-Test -Part2 - Unit Tests.pptx
Demo_MS_Fakes.zip

References

• Writing Great Unit Tests: Best and Worst Practices(http://blog.stevensanderson.com/2009/08/24/writing-great-unit-tests-best-and-worst-practises/ )

• Unit Test or Integration Test and Why You Should Care(http://ardalis.com/unit-test-or-integration-test-and-why-you-should-care  )

• Unit Testing Concepts and Best Practices(http://www.slideshare.net/homespothq/unit-testing-concepts-and-best-practices )

•  Testing for Continuous Delivery with Visual Studio 2012 (http://msdn.microsoft.com/en-us/library/jj159345.aspx)

• Better Unit Testing with Microsoft Fakes (http://vsartesttoolingguide.codeplex.com/releases/view/102290)

01. Create a PDC in an Isolated Internal Network - Setup Virtual Environment for TFS 2013 - Using Virtualbox

This is the first step of Setup Virtual Environment for TFS 2013 - Using Virtualbox. Today I'm going to guide step by step on how to configure a primary domain controller (PDC) on an isolated network environment with Virtual Box.

01. Create a virtual hard disk (.vhd) in virtual box and install Windows 2008 R2 SP1(If you prefer to have Windows 2012 server you can use it as well and all steps more or less similar). Refer this post if you want more information or here is the manual. You can refer to this you tube video as well. Install the Guest Additions to get more control over the VM and host.

02. Once you are ready with the virtual box VM with Win2008R2SP1 shut down the VM and make copy of the virtual box hard disk. Name it as BaseWin2008R2SP1.vhd and keep it as the base hard disk so that you can use it to create other VMs required.

Whenever you want to create a new Win2008R2SP1 VM in virtual box, just make copy of the BaseWin2008R2SP1.vhd and name it as you wish. Then change the uuid as shown here and create a virtual box machine with that .vhd.


03. Now create a VM for PDC using the BaseWin2008R2SP1.vhd as described in above step. Set the network adapter as shown in below image. Provide a name for the Internal Network of Virtual box network(in my case it is Chaminda.net). For more information about different network options with virtual box refer here.

04. Set the other options of the PDC VM as shown below.

05. Start PDC VM and Open Network options and configure an IP. I chose  192.169.1.1

06. Change the VM name as PDC and restart.

07. After restart completed in the run window type dcpromo and hit return key

06. Active Directory Domain Service binaries will be installed and a wizard will popup.

07. Choose advance mode of installation.

08. Create a new domain in new forest

09. Give a name to root domain.

10. If you want a different name for the domain you can change the suggested name.

11. Set the functional level to Window 2008 R2 since we will not be adding additional domain controllers any way.

12. Configure DNS server.

say yes here

13. give a password that you can remember.

14. verify all selected options and hit next.

15. Restart the PDC

16. Password will be the password you have given for the administrator of the machine when you initially set up the machine.

17. PDC is ready now

18. Go to firewall and enable network discovery and file and printer sharing for the domain.

19. Verify IPv4 network properties.

20. Go to server manager and set DNS options as shown below.

 

If IPv6 is set here change it to IP of IPv4.(Right click to get properties)

If you do not understand exactly what you did..do not worry much. Believe me... I did not understand it very much when I did it for the first time..)  and I ruined few attempts. After going through several networking articles figured it out a bit and got some help from networking expert to make it to this far.

So we are done with our primary domain controller. In the next post we can have a look at how to create a VM for TFS server and add it to our newly created domain.

Setup Virtual Environment for TFS 2013 - Using Virtualbox

For anyone interested in learning how to work with TFS & VS for ALM, one of main challenges will be  creating the necessary environment. Of course you can download infamous Brian Keller VMs and use the comprehensive set of hands on labs. But for the folks who are interested in setting up "MY OWN" environment and learn the install & configure stuff (crazy enough to enjoy learning things in a difficult way), I am going to give a complete guide in the coming series of posts.

I will be using Oracle VirtualBox so that you would be able to create a similar environment in your Win7 or Win 8 machines as well.

We will start this journey with creating a Primary Domain Controller (PDC) and I hope to take you through series of activities until we gain experience with VS 2013 Release Management.

 We will be doing this in an Isolated network environment using Virtual Box so that it will not harm the active directory settings of your host machine's corporate domain. you have the option to go with bridged network mode and even expose your virtual environment to outside networks, may be for training purposes. We can discuss all those great stuff after we complete setting up the environment. :)  For more information about different network options with virtual box refer here.

So let's start with the first step and I will keep updating this post as I add more and more posts in this series.

01. Create a PDC in an Isolated Internal Network.
02. Create VM for TFS and add it to the domain.
03. Setup SQL Server for TFS. 
04. Setup SharePoint Foundation 2013 for TFS.
05. Install & Configure TFS 2013
06. Setup a Build Server
07. Setup Development Workstation Base
08. Create Instance of Development Machine
09. Create First Team Project with New Environment 
10. Create a Simple Application and a CI Build
11. Create a Release Build.

I will conclude the series Virtual Environment for TFS 2013 with the post "11. Create a Release Build". Do not worry, as promised when I started this series of posts, I will continue to explain VS 2013 Release Management as a new series using Virtual Environment for TFS 2013.