I'm trying to install Team Foundation Server & need to get SQL Analysis service running but it wouldnt start. This analysis service belongs to a named instance (TFS). Gives me the following message -
The SQL Server Analysis Service (TFS) service on Local Computer
started and then stopped. Some services stop automatically if they
are not in use by other service or programs.
Actually when I'm trying to install TFS it is giving me the following error -
Error 29000. The Team Foundation databases could not be installed.
For more information, see the Microsoft Windows Installer (MSI) log.
On MSDN they mention the cause could be Analysis Service is not running.
http://msdn.microsoft.com/en-us/library/dd266793.aspx#EN29000
Server & Environment Configuration as follows
Windows Server 2008
SQL Server 2005 SP2 Named Instance - TFS
So right now I'm trying to get the Analysis Service up which is configured properly to run under a domain account properly.
Your help will be greatly appreciated.