Error with TFS2010 and remote Analysis Services on SQL2012

If you are trying to get Team Foundation Server 2010 to run with MS SQL Server 2012 Analysis and Reporting services, forget it :-(

After getting this error in Team Foundation Administration Console

I first thought it had to do with the “Client Tools Connectivity” of SQL Server which are required on the TFS application Tier.

After some digging I finally realized, that I missed the obvious.

The SQL2010 assembly has a different version!!!

So it will never work with SQL2012 connectivity tools at least until now with TFS SP1.

Update:

If you install SQL Server 2008R2 Client Tools Connectivity on TFS Application Tier and SQL Server 2012 Client Tools Connectivity (Backwards Compatibility) on the SQL 2012 server it seems to work!
Unfortunately I still have to solve the annoying TF255186 Error with Reporting Services on SQL2012…

Update 2:

Solved!!! Finally solved the last issue by naming the Reporting Services ReportManager URL and WebServices URL by following schema:

http://<ReportServer>/Reports_<InstanceName>
http://<ReportServer>/ReportServer_<InstanceName>

This of course won’t be necessary when your reporting server runs on the default instance of SQL.
Thank you MS for not pointing out that this seems to be a requirement…

http://msdn.microsoft.com/en-us/library/bb552341.aspx

Update 3:

After the installation, I realized, that although everything was setup fine and all databases per created, I still had no access to the reports

Reporting Services answered with

If you look into the SSRS logfile located in C:\Program Files\Microsoft SQL Server\MSRS11.<your instance name>\Reporting Services\LogFiles

I found the error

And

As SQL Server 2012 has the SQL Native Client 11.1 (SQLNCLI11.1) I tried to edit the analysis services datasource to use that provider instead. Unfortunately also that didn’t work.

So I installed the the SQLNCLI10.1 which can be downloaded here also on the DATATIER

http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0x409

pocessed the cube again on the APPTIER by calling the webservice

 http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx?op=ProcessAnalysisDatabase

with the Processing Type: Full

After a while I checked the status of the warehouse by invoking the webservice

http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx?op=GetProcessingStatus

The error about the wrong provider was gone, but now I have the error

Stay posted… ;-)

Update 4:

Solved!

On your DATATIER got to Services and change the “Log on as” account for the “SQL Server Analysis Service (<INSTANCE NAME>)”  to “Local System

Restart the Service

Go to your APPTIER and open the WebService again

http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

Run the actions in the following order

  1. ProcessWarehouse (no parameters)
  2. GetProcessingStatus (no parameters) to check if you the processing is succeeded
  3. ProcessAnalysisDatabase – Parameter: Full
  4. GetProcessingStatus (no parameters)… You should see “Successful” after some time

That’s it! Now open a report and it should display the chart :-)

Note: Microsoft is recommending to use the service instead of doing it manually through SQL Management Studio. In my case the manual task didn’t work and caused even more errors…