TFS2008: Warehouse processing fails “OLE DB error: OLE DB or ODBC error: Cannot open database "TfsWarehouse" requested by the login”

OLE DB error: OLE DB or ODBC error: Cannot open database “TfsWarehouse” requested by the login. The login failed.; 42000. Error while processing TfsWarehouse cube Here is a crisp post by our colleague Vimal, I figured this issue while working with a customer. He kept receiving the Warehouse not processed error while browsing the TFS…


TFS installation and Error 32000

With Team Foundation Server 2005 and 2008 installations, we come across a good number of generic errors. One such error is “Error 32000”. Here is a list of errors and the solutions that might help you. Note: before trying the solutions given below, carefully look at the exception that you get and compare it with…


TFS 2008: Error 32000 while upgrading TFS from 2005 to 2008+SP1

While upgrading Team Foundation Server from 2005 to 2008 with Slipstreamed SP1 you might experiance an error: Error 32000.The Commandline ‘”Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TfsDb.exe” upgrade /server:”SERVER” /property:”TFS_SERVICE_ACCOUNT=SERVER\TFSSERVICE;TFS_REPORTING_ACCOUNT=SERVER\TFSREPORTS;LCID=1033;VSTF_AS_INSTANCE=SERVER;VSTF_AS_DATABASE=TFSWarehouse” /showui:196682’ returned non-zero value: 100. Cause The TFSWarehouse binaries inside the SQL OLAP data folders got corrupt. Log snippet: Upgrading the Warehouse Database (TfsWarehouse)…


TFS 2005 to 2008 Upgrade: While upgrading, Error 32000 due to a bad TFSWarehouse cube.

Cheers everyone, One of our fellow engineers “Vimal” brings this content, While upgrading from 2005 to 2008you might encounter an error   Error 32000.The Commandline ‘”D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TfsDb.exe” upgrade /server: <ServerName> /property:”TFS_SERVICE_ACCOUNT=domainname\TFSService;TFS_REPORTING_ACCOUNT=domainname\TFSREPORTS;LCID=1033;VSTF_AS_INSTANCE=<ServerName>;VSTF_AS_DATABASE=TFSWarehouse;VSTF_AS_ACCOUNT=” /showui:131562’ returned non-zero value: 100.     Cause:  TfsWarehouse cube was corrupt   Resolution: 1) Do not close…