How to find your Analysis Services server

This post provides a C# code snippet to programmatically retrieve the Analysis Services server name for Team Foundation Server (TFS) when it's used for custom reporting. It demonstrates how to connect to a TFS instance, retrieve registration entries for the 'vstfs' tool ID, and extract the SQLServerName associated with the 'BISANALYSIS DB'. This is useful for developers needing to connect to the Team System cube for custom reports, especially when Analysis Services is deployed separately from the data tier server.