title: SQL Server 2008 - Reporting Services Failed Login for User '...'
body: <p>Good Afternoon,</p>
  
  <p>I'm having difficulty running a report with a data source saved on the Report Server using credentials for a user I created on SQL Server named 'ReportUser'.  Attempting to resolve this I've mapped the user to the 'ReportServer' database with the db_owner role as well as setting the default database to the 'ReportServer'.  However, each time I attempt to run the report I receive the error message:</p>
  
  <p><strong>Cannot create a connection to data source 'Test'.  Login failed for user 'ReportUser'.</strong> </p>
  
  <p>I'm running SQL Server 2008 from my local machine and am able to successfully run the reports when I setup the datasource using Windows Authentication.  Any idea on what could be causing the issues when attempting to use the SQL Authentication with the 'ReportUser'  </p>
  
  <p>Thank you very much for your help!</p>