title: SQL Server Analysis Service Freezes When Connecting
body: <p>So I had to uninstall reinstall SQL Server 2012. In doing so I seem to have screwed Analysis Services. </p>
  
  <p>When I attempt to connect to it via SQL Server Management Studio, SSMS just hangs indefinetly while MSSQLServerOLAPService logs</p>
  
  <pre><code>OLE DB error: OLE DB or ODBC error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.; 08001.
  </code></pre>
  
  <p>in the event viewer.</p>
  
  <p>Trying the Deployment Wizard logs</p>
  
  <pre><code>Errors in the metadata manager. An error occurred when loading the SOMECUBE cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\CUBE.0.db\SOMECUBE.4.cub.xml'.
  </code></pre>
  
  <p>Note that <code>C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP</code> does not exist.</p>
  
  <p>From Visual Studio the MSAS part of the project is labeled as <code>(incompatible)</code>. </p>
  
  <p>I can see the service <code>SQL Server Analysis Services (MSSQLSERVER)</code> as <code>Started</code>.</p>
  
  <p>Also, when I check the install (by trying to install an addon) I can see that SQL Server Analysis Services is already installed.</p>
  
  <p>I'm thinking that the cubes from my old install are causing me grief, but I'm unsure how to go about correcting the problem.</p>
  
  <p>EDIT: <code>C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP</code> does, I missed the MSAS part...Also this does have files left over from last install. </p>
  
  <p>EDIT: Cleaning out the folder allowed me to add cubes but I cannot process them yet. Says sql server  instance does not exist</p>