title: Sending SSRS credentials via C# application
body: <p>I am currently working on a <code>C#</code> application for my company that goes out to our <code>SSRS</code> server, runs specific reports, formats the excel reports in the application, and then spits them out to a location.<br>
  The application is working as intended and there is just one little annoyance.<br>
  Every time a specific report type is run the <code>credentials</code> for <code>SSRS</code> must be entered.<br>
  We are opening the <code>excel file</code> with the report's URL as the file name.<br>
  This is the code that actually opens the <code>excel</code> file from our application: </p>
  
  <pre><code>Microsoft.Office.Interop.Excel.Workbook excelActiveBook; 
  excelActiveBook = excelApp.Workbooks.Open(reportURL, 0, false, 5,     System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value, true, false, System.Reflection.Missing.Value, false, false, false);
  </code></pre>
  
  <p>Is there any way to pass in <code>credentials</code> to <code>SSRS</code> through this application we have written.<br>
  We are using <code>SSRS 2005</code>.</p>