title: Unable to connect to data source. Reason: Unable to locate database server
body: <p>I am trying to use Excel 2007 to connect to my 2008 Analysis Server (64 bit SQL 2008 on Small Business Server 2008).</p>
  
  <p>From Excel, I go:
  Data --> From Other Sources --> From Analysis Services</p>
  
  <p>Then I get an error message: Unable to connect to data source. Reason: Unable to locate database server.</p>
  
  <p>Should this functionality work out of the box? Or do I need to install an add-in or something?</p>
  
  <p>thanks</p>