I have a TFS install which I think was never really successfully installed. I'm using it just for single-developer source control so I don't care about any analysis type functionality.
When trying to upgrade SQL Server 2005 to SQL Server 2008 I ran into this error even though the service was actually started in the services control panel. It continued anyway but then left me with an incomplete install of SQL Server 2008.
Configuration error description: Unable to Connect to Analysis Services with name 'MSSQLServerOLAPService', please start the service and try the upgrade process.
If I go into the
Surface Area Configuration for SQL Server 2005 Analysis Services I get this error immediately:
Errors in the metadata manager. The dimension with ID of 'Scenario', Name of 'Scenario' referenced by the 'Team System' cube, does not exist. Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, '\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Team System.15989.cub.xml'. (Microsoft.AnalysisServices)
So I'm thinking of basically uninstalling the failed
SQL Server 2008 and then uninstalling the broken
2005 analysis services. I don't think I care about it anyway but I'm not compleetley sure.
What happens if I uninstall analysis services? Does TFS break for the basic source control functionality or will it just be reporting that doesn't work - which i'm not even using anyway?
Are these analysis services used for anything else if I'm not explicitly aware that I'm using them?