title: OLE DB error: OLE DB or ODBC error:
body: <p>I am trying to connect from my SSAS server to SQL through SSMS and the connection works fine when I test it. But when I am processing the cube, I am getting the below error message.</p>
  
  <pre><code>  OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
  </code></pre>
  
  <p>I have looked the other similar error message that was posted and tried the below options as per the suggestions.</p>
  
  <p><a href="https://stackoverflow.com/questions/25409639/ssas-ole-db-error-in-establishing-a-connection">SSAS - OLE DB error in establishing a connection</a></p>
  
  <pre><code>1. Restart SSAS Service
  2. Restart SSAS using local system
  3. Trying to change the Provider to Native OLE DB\Microsoft OLE DB Provider for SQL server, but still I am getting the below error 
  
      OLE DB error: OLE DB or ODBC error.
  </code></pre>
  
  <p>I am stuck with this for more than 3 days and not able to progress anything beyond. I tried all other Providers as well and still it doesn't work.</p>
  
  <p>Additionally I made sure that the Windows account I am using in data source of SSAS server is having db_owner on the SQL data base.</p>
  
  <p>Any help would be really appreciated to get me out of this. </p>