title: Connecting to Analysis Services in SQL Server 2008
body: <p>Okay, this may be an insanely stupid question, but how in the world do I connect to Analysis Services in SQL Server 2008?</p>
  <p>Basically, I have no idea what to put as my Server Name.</p>
  <p><img src="https://i.stack.imgur.com/K48ad.png" alt="enter image description here" /></p>
  <p>When I connect to a Database Engine, I'm using mycompname\SQLEXPRESS. If I try to put that as my Server name when connecting to Analysis Services, I get an error saying:</p>
  <blockquote>
  <p>Cannot connect to mycompname\SQLEXPRESS.</p>
  <p>A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)</p>
  <p>No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)</p>
  </blockquote>
  <p>Here's my SQL Server 2008 component information:</p>
  <ul>
  <li>Microsoft SQL Server Management Studio - 10.0.1600.22
  ((SQL_PreRelease).080709-1414)</li>
  <li>Microsoft Analysis Services Client Tools - 2007.0100.1600.022
  ((SQL_PreRelease).080709-1414)</li>
  <li>Microsoft Data Access Components (MDAC)  - 6.1.7601.17514
  (win7sp1_rtm.101119-1850)</li>
  <li>Microsoft MSXML - 3.0 4.0 6.0</li>
  <li>Microsoft Internet Explorer - 9.0.8112.16421</li>
  <li>Microsoft .NET Framework - 2.0.50727.5466</li>
  <li>Operating System - 6.1.7601</li>
  </ul>