TFS 2013 installation error: TF400069 You must install either SQL Server Analysis Services version 11.0
Rolling out a Team Foundation Server environment is always an adventure. Everytime I discover some new stuff. Last week at a customer I was setting up a new Team Foundation Server 2013 server when I got the following error message:
TF400069: You must install either SQL Server Analysis Services version 11.0 or the SQL Server Client Tools.
Did I forgot to install something? I went through the SQL Server Installation wizard(slow!) to see that I had indeed the SQL Server Client Tools installed. Just in case, I removed and reinstalled them… no difference. I had no clue so I even tried to install the SQL Server Analysis Services but even that made no difference.
It took me some time to figure out what I did wrong. Let’s have a second look at the error message (and especially look at the highlighted text):
TF400069: You must install either SQL Server Analysis Services version 11.0 or the SQL Server Client Tools.
Team Foundation Server 2013 requires at least SQL Server 2012 with SP1, I had installed the SQL Server 2008 R2 version .