Migrating Team Foundation Server 2013 Databases and all Databases in SharePoint 2013 to a New Server


This post could be used for many scenarios as the following,

Scenario 1:
Migrate Team Foundation Server’s SQL Server to another machine, Migrating Team Foundation Server Databases, moving TFS configuration Database to another SQL Server

Following  steps:
Step-1, step-2, step-4, step-5, step-6, step-7, step-8, step-9, step-11, step-13

===================================================

Scenario 2:
Move all databases in SharePoint 2013, Moving SharePoint Content Databases to a New Server, Migrate SharePoint’s SQL Server to another SQL Server, Moving SharePoint to a different SQL server

Following  steps:
Step-1, step-3, step-4, step-5, step-7, step-10, step-12

===================================================

Scenario 3:
Migrating Team Foundation Server Databases and all databases in SharePoint 2013 to a New Server

Following  steps:
All steps

The list of all steps:

  1. Installing MS SQL Server 2014
  2. Stop IIS and all TFS Services
  3. Stop IIS and all SharePoint Services
  4. Share a folder and turn off firewall
  5. Backup DBs and store them on the shared folder
  6. Backup SQL Server Reporting encryption key
  7. Restore DBs to the new SQL Server machine
  8. Remap Reporting DB and restore encryption key
  9. Remap and configure TFS for the new DB server
  10. Remap and configure SharePoint for the new DB server
  11. Start IIS and all TFS Services again
  12. Verify SharePoint DB migration
  13. Verify TFS DB migration
  14. Note-1 DotNet Framework cannot be installed
  15. Note-2 Fix SharePoint error cannot open DB
  16. Note-3 Fix SharePoint error cannot open sites
  17. Note-4 Repair TFS connection with SharePoint
  18. Note-5 Analysis DB backup and restore

 

1-Installing MS SQL Server 2014

2-Stop IIS and all TFS Services

3-Stop IIS and all SharePoint Services

4- Share a folder and turn off firewall

5-Backup DBs and store them on the shared folder

6-Backup SQL Server Reporting encryption key

7-Restore DBs to the new SQL Server machine

8-Remap Reporting DB and restore encryption key

9-Remap and configure TFS for the new DB server

10-Remap and configure SharePoint for the new DB server

11-Start IIS and all TFS Services again

12-Verify SharePoint DB migration

13-Verify TFS DB migration

14-Note-1 DotNet Framework cannot be installed

15-Note-2 Fix SharePoint error cannot open DB

16-Note-3 Fix SharePoint error cannot open sites

17-Note-4 Repair TFS connection with SharePoint

18-Note-5 Analysis DB backup and restore

Configuring Lab Management 2013 for SCVMM 2012 R2 Environments


In this post I will explain with videos how to configure Lab Management 2013 with SCVMM 2012 R2 so we can create and manage SCVMM environments in Team Foundation Server 2013, for more information, visit the MSDN Configuring Lab Management for SCVMM Environments

The following are the steps:

  1. Installing HV and verifying it is working properly
  2. Improving the reliability of WinRM
  3. Installing SCVMM 2012 R2 prerequisites
  4. Creating 2 folders SCVMM Library and SCVMM VMs
  5. Installing SCVMM 2012 R2
  6. Adding Hyper-V Host to SCVMM 2012 R2
  7. Installing SCVMM Admin Console on TFS machine
  8. Configure Lab Management for Team Foundation Server
  9. Installing and configuring Test Controller
  10. Verifying Lab Management and Test Controller Configured successfully
  11. Note-1 Stopping and Starting WinRM with SCVMM
  12. Note-2 Fix SPN that VMM requires were not correctly registered

1- Installing Hyper-V and verifying it is working properly

2- Improving the reliability of WinRM
See how to increase the maxtimeoutms for Windows Remote Management and this is required for Lab Management

3-Installing SCVMM 2012 R2 prerequisites
See how to install System Center Virtual Machine Manager 2012 R2 Prerequisites

4-Creating 2 folders SCVMM Library and SCVMM VMs
Creating one folder for the Library share that will hold templates and VMs and another folder for the deployed VMs

5-Installing SCVMM 2012 R2

6-Adding Hyper-V Host to SCVMM 2012 R2

7-Installing SCVMM Admin Console on TFS machine

8-Configure Lab Management for Team Foundation Server

9-Installing and configuring Test Controller

10-Verifying Lab Management and Test Controller Configured successfully

11-Note-1 Stopping and Starting WinRM with SCVMM
In case you want to stop and start Windows Remote Management with System Center Virtual Machine Manager installed, because we have to stop System Center Virtual Machine Management Agent and start it manually

12-Note-2 Fix SPN that VMM requires were not correctly registered
See the following video if you encounter the following error:

The Service Principal Names (SPNs) that VMM requires were not correctly registered when the VMM management server

TFS Update 4 CTP 2 Features and installation


Microsoft released Visual Studio 2013 Update 4 Community Technology Preview 2 (CTP 2) on September 22, 2014, it includes some new features and bug fixes.

For more information about this release visit the KB: https://support2.microsoft.com/kb/2994375

This post has main 2 sections:

Team Foundation Server Features

  • Web Access can return directly to query results from a detailed view of the query by using a context menu.
  • Web Access can generate an email directly from the work item view by using a new toolbar command.
  • Web Access has a full-screen option to view query results.
  • The free Stakeholder license provides access to the project home page from which Stakeholders can view the backlog, edit items, run work item queries, and many other operations.
  • Agile teams can have up to 999 work items in the first or last column of the Kanban board.
  • Web Access now opens a work item in a new window or tab.
  • You can maximize (or full screen) fields for quick readability when the rich text editor does not have enough space.

Installation and configuration

  • What you need to know before you install
  • How to install and configure.

Team Foundation Server Features

The following is the walk through video

  • Web Access can return directly to query results from a detailed view of the query by using a context menu.

In the Team Web Access if you run a query and open a work-item from the query result, you can get back to the query result from the work-item context menu on the top-right.

9-25-2014 5-56-27 PM

9-25-2014 5-58-17 PM

  • Web Access can generate an email directly from the work item view by using a new toolbar command.

In the previous update 3, you can send email from the context menu only but now you can send email from the work-item tool bar.
image005
9-25-2014 6-29-13 PM

  • Web Access has a full-screen option to view query results.

Now you can full-screen for the query result for better readability

9-25-2014 6-32-19 PM

image011

  • The free Stakeholder license provides access to the project home page from which Stakeholders can view the backlog, edit items, run work item queries, and many other operations.

There is new Access level feature for the Stakeholder that give them more features then the limited level

9-25-2014 6-35-07 PM

  •  Agile teams can have up to 999 work items in the first or last column of the Kanban board.

9-25-2014 6-37-38 PM

  •  Web Access now opens a work item in a new window or tab.

9-25-2014 8-50-03 PM

  • You can maximize (or full screen) fields for quick readability when the rich text editor does not have enough space.

9-25-2014 6-44-48 PM9-25-2014 6-45-29 PM

Installation and configuration

The following is the walk through video

  • What you need to know before you install

This installation not for production and can’t be upgrade, the only purpose for features evaluation and feedback

image023

  •  How to install and configure.

Installation time (20 minutes)

Configuration time (5 minutes)

This installation doesn’t support layout switch, so you will need to install the web installer.

9-25-2014 4-34-11 PM

For the supported switches type tfs_server.exe/?

9-25-2014 4-34-42 PM

TFSConfig Lab /Delete Command


In a previous post, I explained when you should and should not remove Lab Management resources like (Templates, VMs , Environments) for more information click here

In this post I will show and explain the different options for TFSConfig Lab /Delete switch

What will happen if we run the following command:


tfsconfig lab /delete /collectionName:DefaultCollection 

This will remove all lab managements resources from the collection but it will leave them in SCVMM, see the following video:

What will happen if we run the following command with /External switch:


tfsconfig lab /delete /collectionName:DefaultCollection /external

This will remove all lab managements resources from the collection and also remove them from SCVMM and the Hyper-V host, see the following video:

For more information about TFSConfig lab /delete command, click here

TFS259201 the following host group does not contain any logical network Resolve any issue on host group


In Team Foundation Server, if you try to create SCVMM Lab Environment and you encounter the following error:

TFS259201 the following host group does not contain any logical network Resolve any issue on host group

TFS259201

You can solve this issue as the following:
Add logical network as the following:
SCVMM Logical Network

As we can see the created logical network was not associated with network adapterLogical Network assign network adapter

Add a network adapter to the logical network
Assing Logical network

Release Burndown Reporting Service Error


In Team Foundation Server, if you use Scrum template and all reports that deplyed to SharePoint are working properly excpet “Release Burndown” not working, and you encounter the following error

Release Burndown Reporting Service Error

Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) sql reporting

TFS Reporting Service error

You only need to give start and end date for iterations

Add start date and end date for iteration tfs

Remember you will need to wait for the warehouse job to run or just manually run it, click here for more info

You should not see the error again even if you don’t have data.

Release burndown tfs reporting service fix