logo
Menu

Aaron Stanley King

I solve problems -- occasionally code is involved.

Dual Server TFS installation Reporting Services Edition error

I don't install Team Foundation Server too often anymore.  I've been doing a lot of development and not a lot of managing teams.  This is a good thing. 

The first thing you should to when doing a dual server install is run this query on your SQL Server.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') 

Then install Reporting Services on your Team Foundation Server according to this chart.  If not, it won't work.

For this edition of SQL Server 2005 Reporting Services Use this edition of the Database Engine instance to host the database
SQL Server 2005 Express Edition with Advanced Services SQL Server 2005 Express Edition with Advanced Services (local only).
Workgroup Edition Workgroup Edition (local only)
Evaluation Edition Standard, Evaluation, Enterprise Editions (local or remote)
Developer Edition Standard, Developer, Enterprise Editions (local or remote)
Standard Edition Standard, Enterprise Editions (local or remote)
Enterprise Edition Standard, Enterprise Editions (local or remote)