Håkan Winther avatar image
Håkan Winther asked

TFSWarehouse cannot access Analysis services

I think this question should be asked at, but I give you guys a chanse to answer it first. Our client installed Team Foundation Server 2008 SP1 (TFS) on one server and the SQL server 2005 with the TFS databases on another server. The TFS works just fine, but the warehouse doesn't get loaded with statistics.

Every half hour we get the following error in the Eventlog on the TFS server.

SQL Server does not exist or access denied.;

The account assigned to the TFS services is configured in the SQL server and we can connect to the relation database "TFSWarehouse" and the analysis server database "TFSWarehouse" with that account. We can manually process the cube from analysis service, but the relation datbase is empty.

Does anyone have any idea. It looks like it is connecting to a different server than the other TFS services

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Did you get an answer from the ServerFault guys? If so, what was it? Or is it so old that you can't remember?
0 Likes 0 ·

0 Answers