title: Typing in password for every connected table from SQL Server 2008 R2 in Excel 2010 Powerpivot Addin
body: <p>I've got a BI Dashboard in Excel 2010 using Powerpivot, which is connected to a number queried tables on one SQL Server. When the connections were setup, I checked the box to 'save password' on each one. However, whenever my users reopen the document and go to the Powerpivot window and select 'RefreshAll' then they have to type in the password multiple times (once for each table), which is not suitable.</p>
  
  <p>I have looked <a href="http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/0cacf05a-6e76-4b38-80ac-16c0a13c1e3d">here</a> and <a href="http://blogs.msdn.com/b/sqlazure/archive/2010/06/23/10029164.aspx">here</a> and seem to be experiencing the same issue as a number of other people. I have started again from scratch, ensuring that the 'save password' box is definitely checked on each connection string. </p>
  
  <p>The only workaround I can think of is by user Windows Authentication, but this document is intended for widespread use, and as such this will require a lot of maintenance, and will really annoy my server admin :)</p>
  
  <p>Does anyone have a workaround, or any way of resolving the problem?</p>