Report question

Question: Typing in password for every connected table from SQL Server 2008 R2 in Excel 2010 Powerpivot Addin