How to perform an in-place upgrade from SQL Express to SQL Server other editions?

by XDK 17. July 2015 09:28

Solution:

1. Open Command prompt with "Run as Administrator" permission

2. Change directory to your SQL server setup/install folder

3. Execute the follwoing command

setup /ACTION=editionupgrade /INSTANCENAME=SQLEXPRESS /PID=XXXXX-XXXXX-XXXXX-XXXXX

  • INSTANCENAME - Existing SQL EXPRESS instance you want to upgrade
  • PID - Product Key

Tags:

SQL Server

TF31002: Unable to connect to this Team Foundation Server

by XDK 14. May 2015 06:52
Explanation:
Ensure the proxy settings are set correct. You may face TFS connection issues when the proxy settings 
have changed or are incorrect.

Note: The .NET and Visual Studio use the proxy settings from Internet Explorer 

Tags: ,

Azure DevOps on-premises | Visual Studio 2010 | Visual Studio 2012 | Visual Studio 2013

TF400167 : Installation failed for the package (tfs_sharePointExtensionsCoreRes_X64) with thw follwoing status 0x80070652, restart state 00x0

by XDK 12. May 2015 07:24
Exception:
TF400167 : Installation failed for the package (tfs_sharePointExtensionsCoreRes_X64)
with thw follwoing status 0x80070652, restart state 00x0.
Error : Installation failed.
Check individual package installation errors for more information. 

Explanation:

The above exception occurred while installing or upgrading the build environment to TFS 2013 update 4. 

Workaround:

Delete the folders and files under "C:\program Data\Package cache" directory and start the install again.

Tags: ,

Team Build | Azure DevOps on-premises | TFS 2013

Some of the reviewers don't have permssion to some of the files to review. Do you want to submit the code review anyway?

by XDK 6. May 2015 13:35

Exception:

Explanation:

The above warning message is reproducible when the users have duplicate display names in Tfs_Configuration’s identity table.

Workaround:

Change the display name in TFS profile.

1. Navigate to Web Access and load a Team Project that has the Display Name you want to change.

2. Navigate to the Administration page by selecting Administer Settings option on the top right hand corner of the Web Access page.

3. Click on the drop down arrow next to your name

4. Select "USER PROFILE"

5. Click Edit to modify your Display Name.

6. Click "Save changes" button.

Tags: , ,

Azure DevOps on-premises | TFS 2012 | TFS 2013

Area or Iteration path created in the project is not reflected in the TFS cube/SSAS

by XDK 28. April 2015 18:11

Explanation: 

TFS cube gets refreshed 2 hours once. You should have at least  one work item assigned to the specific area or iteration path to get reflected in the cube or available in the report.

Tags: , ,

TFS 2010 | TFS 2012 | TFS 2013

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.