Failure to Launch (TFS - Redux after I thought I had fixed it)

Question

I'm having an insane time trying to figure out this connection error I'm getting.  I have a TFS server trying to connect to a remote TFSWarehouse server.  Every time I try to run the "Run" control from the ControllerService web page, I generate an error in the error log that reads, in part:

Detailed Message: Cube processing runtime error: \r\nMicrosoft.AnalysisServices.OperationException: Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
OLE DB error: OLE DB or ODBC error: Cannot open database "TfsWarehouse" requested by the login. The login failed.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'TfsWarehouseDataSource', Name of 'TfsWarehouseDataSource'.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Run', Name of 'Run' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Run ID' attribute of the 'Run' dimension from the 'TfsWarehouse' database was being processed.

Obviously this is an ODBC connection error, but I cannot determine what credentials it's trying to use, or what service's logon I need to change.  The logons for the SSRS, Server Task Scheduler, and VSS Writer are all able to connect to the remote system fine if done outside of the scope of TFS. 

Thanks in advance,
Offey

Answer 1

 

Hey Offey,

 

I am experiencing exactly the same issue. A few questions regarding your environment:

 

- Is this regarding TFS 2008?

- Do you have a service domain account for Analysis services?

- Do you have a service domain account for Reporting Services? If so - is it different than the TFS reports account (say you might have Reporting Services service account as SQLReporting Services when you installed SQL, but in TFS wizard specify TFSReports as the account you want to use for reports).

 

 

I managed to get through this error, by granting my SQLAnalysis service account public and TFSWarehouseDataReader  rights over the TFSWarehouse DB (force - processing the cube through analysis services worked then) and having Reporting services run as the same account i specified in TFS (TFSReports) and but now i am getting a different error so I'm not sure if I am even on the right path.

 

 

I had the whole server runnig perfectly yesterday (had the same issue initially, but managed to resolve it), but i thought I'd try reinstalling to make sure I didn't screw up anything when i installed the first time around.. and now im stuck

 

 

Maxim

Answer 2

Heya Maxim.

I'm pretty sure that it's TFS 2005.  That being said, the Analysis Services account on the warehouse server is different from the service account for reporting services on the application server, that's true.  Both are domain accounts.  I cannot speak to what happened during setup as I was not employed here at the time . 

So, you got it working, thought "Hey, I got it working, I'ma reinstall" and it's broken again?   That's gambling.  I'd be happy if I could just get it to roll up one time.  I'll try those things when these guys give me a window to change it.

I appreciate the help, and will check back.

Thanks,
O.

Answer 3

 

While I did get it working the first time i went through quite a bit of troubleshooting such as flipping Reporting Services Accounts, granting service accounts permissions to several places (for example i granted my reports account access to analysis services, and the analysis account the permissions I mentioned above), recreating IIS application pool, rebuilding, deleting and recreating the cube several times, etc. The install got a bit dirty, so since this is going to be a production box and I want it to be as clean as possible.

 

Anyway, enough about that - I just got it working again.

 

Here is what I did :

 

- Granted my Analysis Services account public and TFSWarehouseDataReader permissions over the TFSWarehouse Database (in SQL management Studio >Database Engine). I couldn't process the cube unless I had this permission (and was getting the error you described in your first post).

- Connected to Analysis services using SQL Management studio and granted my TFSReports account permissions to connect to it (note that TFSService was already there). Without this I would get an error that the TFSReports account did not have permissions over the "TFSWarehouse database'. I think this referst to the Database in Analysis Services rather than the one available through the database engine.

- Here's the kicker - I had to do something else so I stopped troubleshooting this for 15-20 minutes. When I came back I refreshed my TFS WSS project portal web page and noticed the reports worked. I noticed the warehouse last update time was about 5 minutes ago. I also confirmed the reports are fine from the actual reporting services page. I'm not sure what kind of an update kicked in while I was away, but you might want to keep this in mind when troulbeshooting.

 

Maxim

 

 

 

 

Answer 4

I think that got it.  I was able to do the Run from the Web-Based Service page and got no errors at all.  Thanks a lot, Maxim, if I had come up in here 7 hours ago, I could have saved myself a headache

Again, I appreciate it,
O.