TFS Install and Configuration Requirements

by XDK 5. February 2014 09:59
TFS Server install requirements TFS 2012 TFS 2013 TCP Ports  Accounts
Server Operating System          
Versions        
Windows Server 2008 SP2 (Standard, Enterprise, Datacenter) Yes No    
Windows Server 2008 R2 SP1 (Standard, Enterprise, Datacenter) Yes Yes    
Windows Server 2012 (Essentials, Standard, Datacenter) Yes Yes    
Windows Small Business Server 2011 (Essentials, Standard, Premium Add-On) Yes Yes    
Windows Home Server 2011 Yes No    
Windows Server 2012 R2 (Essentials, Standard, Datacenter) No Yes    
Default Ports        
Team Foundation Server     8080  
Team Foundation Server Proxy     8081  
Service accounts        
TFS        TFSSERVICE
TFS Proxy        TFSPROXY
SQL Server          
Versions        
SQL Server 2008 R2 (Express, Standard Edition, Enterprise Edition) Yes No    
SQL Server 2012 (Standard Edition, Enterprise Edition) Yes No    
SQL Server 2012 SP1 Yes Yes    
Features & configuration        
SQL Core        
Database Engine Services Yes Yes    
Full-Text and Semantic Extractions for Search Yes Yes    
Reporting        
Reporting Services – Native Yes Yes    
Analysis Services Yes Yes    
Collation settings        
Must be accent sensitive Yes Yes    
Must not be case sensitive Yes Yes    
Must not be Binary Yes Yes    
Must not be Binary - code point Yes Yes    
Authentication        
Windows authentication Yes Yes    
Service accounts        
SQL Server        SQLSERVICE
SSRS        TFSREPORTS
Default Ports        
SQL Service (Database Engine)     1433  
SQL Browser Service (Database Engine)     1434  
SQL Server Analysis Services Redirector      2382  
SQL Server Analysis Services     2383  
SQL Server Reporting Services     80  
SharePoint        
Versions        
Windows SharePoint Services 3.0 (Foundation, Standard, Enterprise) Yes No    
Microsoft Office SharePoint Server 2007 (Foundation, Standard, Enterprise) Yes No    
Microsoft SharePoint Server 2010 (Foundation, Standard, Enterprise) Yes Yes    
Microsoft Office SharePoint Server 2010 (Foundation, Standard, Enterprise) Yes Yes    
Microsoft SharePoint 2013 (Foundation, Standard, Enterprise) Yes Yes    
Microsoft Office SharePoint Server 2013 (Foundation, Standard, Enterprise) Yes Yes    
Default Ports        
Default website     80  
SharePoint Central Administration     17012  
Service accounts        
SharePoint Products        WSSSERVICE
Team Build OS         
Versions        
Windows Server 2008 SP2 (Standard, Enterprise, Datacenter) Yes No    
Windows Server 2008 R2 SP1 (Standard, Enterprise, Datacenter) Yes Yes    
Windows Small Business Server 2011, with latest SP Yes Yes    
Windows Server 2012 (Essentials, Standard, Datacenter) Yes Yes    
Windows Server 2012 R2 (Essentials, Standard, Datacenter) Yes Yes    
Windows 7 32-/64-bit (Home Premium, Professional, Enterprise, Ultimate), with latest SP Yes Yes    
Windows 8 32-/64-bit (Basic, Pro, Enterprise) Yes Yes    
Windows 8.1 (Basic, Pro, Enterprise) Yes Yes    
Default Ports        
Build     80  
Service accounts        TFSBUILD
Team Foundation Build      9191  
Project Server        
Versions        
Project Server 2007 Yes No    
Project Server 2010 Yes Yes    
Project Server 2013 Yes Yes    

 Reference : 

 

Tags: ,

Azure DevOps on-premises | TFS 2012 | TFS 2013

Load Test: The test has not started yet

by XDK 4. February 2014 14:06

Exception:

"The test has not started yet"

Explanation:

The test run result window just lists the name of the machine from which it ran, but it never opens the results and also Test run state remains pending. After I double click on the machine test item it just says "The Test has not started yet". Not able to view the result online during load test execution time. 

 

Solution:

The VS 2010 client version which I used to execute the load was SP1. But the test rig environment version was only VS 2010 RTM. 

1. Installed the SP1 on test controller and agents

2. Reconfigured the agents to controller again.

Tags:

Azure DevOps on-premises | TFS 2010 | Web Performance & Load Tests

About Test Attachment Cleaner

by XDK 30. January 2014 11:37

Explanation:

A command line tool that only removes the attachments. It does not touch the test runs, which contain the pass/fail data. So, running Test Attachment Cleaner will not impact the record of the test runs.

You need to Test Attachment Cleaner if you:

  1. Do manual test runs and want to delete attachments without deleting the test runs
  2. Do automated test runs and want to delete attachment for builds which have been deleted already, but the build definition’s retention policy was not set to delete “test results” (because this is turned off by default)

You do not need the Test Attachment Cleaner if you:

  1. Have automated test runs triggered by a build, and you have configured the build definition’s retention policy to delete “test results” (which is not set by default)
  2. Delete the Test Runs manually (as this deletes the attachments)

 SQL Query to get the attachment type associated with the team project.

Select projects.ProjectName, SUBSTRING(attachments.filename,

len(attachments.filename)-CHARINDEX('.',REVERSE(attachments.filename))+2,999) as Extension, sum(f.compressedlength)/1024/1024 as SizeInMB
From tbl_Attachment as attachments
INNER JOIN tbl_File as f on attachments.TfsFileId=f.fileid
INNER JOIN tbl_TestRun as tr on attachments.TestRunId = tr.TestRunId
INNER JOIN tbl_Project as projects on tr.ProjectId = projects.ProjectId
Group by projects.ProjectName, SUBSTRING(attachments.filename,len(attachments.filename)-CHARINDEX('.',REVERSE(attachments.filename))+2,999)
Order by sum(f.compressedlength) desc


Download Attachment Cleaner

Command to preview the attachments before delete
tcmpt attachmentcleanup /collection:TfsUrl /teamproject:TeamProjectName /settingsfile:SettingsFile /outputfile
:<Output dir>/teamproject.log /mode:preview
Command to delete the attachments
tcmpt attachmentcleanup /collection:TfsUrl /teamproject:TeamProjectName /settingsfile:SettingsFile /outputfile:<Output dir>/teamproject.log

Sample settingsfile

<DeletionCriteria>
  <TestRun/>
  <Attachment>
    <SizeInMB GreaterThan="50"/>   
  </Attachment>
  <LinkedBugs>
    <Excludestate="New"/>
    <Excludestate="Committed"/>
    <Excludestate="Approved"/>
  </LinkedBugs>
</DeletionCriteria>

Tags:

MTM | TFS 2010 | TFS 2012 | TFS 2013

Unknown domain users displayed in the work items "assigned to" field

by XDK 29. January 2014 16:57

Description:

IT administrators account get populated in the work item "assigned to" field.

By default, [TEAM FOUNDATION]\Valid Users include [TEAM FOUNDATION]\Team Foundation Administrators which holds [BUILT IN]\Administrators.

Workaround:

In the TFS Server Administration Console

1. Select Application Tier and clicked Group Membership. I

2. Double-click on [TEAM FOUNDATION]\Team Foundation Administrators 

3. Remove [BUILT IN]\Administrator

Tags:

TFS 2010 | TFS 2012 | TFS 2013

After a Gated check-in Build, reconcile or ignore pop up dialog\message is missing

by XDK 29. January 2014 09:04

Explanation:

This issue may occur If you have multiple Visual Studio version instances installed in your box

Solution 1:

Make sure the BuildNotification.exe version loaded in your box matches the Visual Studio version you used for development

BuildNotification.exe for Visaul Studio 2012 will be located at <drive>:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE

Solution 2:

1. Exit out of the BuildNotification tool from taskbar. (right click and Exit).

2. Navigate to <drive>:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE

3. Open BuildNotification.exe.config

4. Edit the trace in there to uncomment to capture the trace. 

Original from:

  <!-- enable soap tracing by uncommenting the following  

  <appSettings>

    <add key="TFTrace.Writer" value="true" />

    <add key="TFTrace.DirectoryName" value="%TEMP%\\TFLogFiles" />

    <add key="TeamFoundationSoapProxy.EnableSoapTracing" value="true" />

  </appSettings>

   <system.diagnostics>

    <switches>

      <add name="TeamFoundationSoapProxy" value="4" />

      <add name="General" value="4" />

    </switches>

    <trace autoflush="true" indentsize="3"/>

  </system.diagnostics>

-->

</configuration>

 to:

  <!-- enable soap tracing by uncommenting the following  -->

  <appSettings>

    <add key="TFTrace.Writer" value="true" />

    <add key="TFTrace.DirectoryName" value="%TEMP%\\TFLogFiles" />

    <add key="TeamFoundationSoapProxy.EnableSoapTracing" value="true" />

  </appSettings>

   <system.diagnostics>

    <switches>

      <add name="TeamFoundationSoapProxy" value="4" />

      <add name="General" value="4" />

    </switches>

    <trace autoflush="true" indentsize="3"/>

  </system.diagnostics>

 </configuration>

 5. Save the trace.

** You might have to open notepad.exe as Administrator if it does not allow you to save it.

** Don't close notepad, because you will need to undo this tracing later.

6. Run "Build Notification" from TFS2012.

7. Trigger a Gated Build. Once the build complete, wait for a few minutes to confirm the dialog appears.

If it works, you can undo the steps from 1-6 again to undo the steps.

 

Tags:

About the author

My name is Xavier Dilip Kumar Jayaraj having 16+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Microsoft Certified: Azure Administrator Associate

Microsoft Certified: Azure DevOps Engineer Expert

DevOps Engineer Certificate Program | Transcript 

OTP-AWSD5: AWS IoT: Developing and Deploying an Internet of Things

[PCEP-30-01] PCEP – Certified Entry-Level Python Programmer

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

CategoryList

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.