Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SQL Server 2008 R2 Database, Reporting and Analysis Services installed on Server A. On Server B, I am trying to configure Team Foundation Server using the Advanced Configuration Wizard. Pretty much everything seems to be okay except for the Analysis Services part. When I set my SQL Server Analysis Services Instance path and try to test it, I receive the following error message:

TF255040: You must exit the Team Foundation Admin console and install SQL Server Reporting Services or at a minimum SQL Client Connectivity Tools on the application tier to ensure Analysis Services object model is present for warehouse processing. Once you have installed the necessary reporting components, re-start the admin console and re-run the wizard.

Well, I don't want to install the SQL Server Reporting Services on Server B. As far as SQL Client Connectivity Tools, I am not sure what it is referring to. Should I install the SQL Server Management Studio on Server B?

Note: I have enabled the firewall exception for Analysis Services on Server A and I am able to connect to it from another machine.

share|improve this question
up vote 5 down vote accepted

"Client Tools Connectivity" is one of the available SQL Server shared install options you can choose locally without installing any of the server components.

Run the SQL Server installer and ensure you deselect everything else (that you have not installed to provide connectivity).

Should I install the SQL Server Management Studio on Server B?

You don't need this on the application tier, but if it is there it can be used for remote management of your data tier.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.