title: Excel Connectivity with SSAS - An error was encountered in the transport layer
body: <p>I have a SSAS Cube in SQL 2012 to which I can connect from Excel 2010 without an issue using a windows user credentials. However whenever I restart the server hosting the cube and I try to refresh the pivot in the excel (in a client machine) it throws and an error saying "<strong>An error was encountered in the transport layer</strong>". I am then prompted to re-enter the password for the windows account I am using to connect to the data source. </p>
  
  <p>The problem is that if I have couple of pivots open in different sheets in the same excel book per each pivot I am prompted to do this (even if I do a Refresh and not a Refresh All) which is bit of a trouble. </p>
  
  <p>Is there a way to fix this or at least to make sure I have to enter the password only once and it will not seek for each and every pivot being refreshed? </p>