title: How to fix rsLogonFailed error message when executing report
body: <p>I just installed SQL 2012 Enterprise on a laptop running windows 10 Pro x64.
  When I try to execute my SSRS reports from the report manager, I always get the same error: </p>
  
  <p>An error has occurred during report processing. (rsProcessingAborted)
  Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)
  Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
  The user name or password is incorrect</p>
  
  <p>I am using integrated windows authentication with a domain account.
  The domain account can log on through SSMS and can access the databases with no issue and run queries.</p>
  
  <p>I have also tried using a local SQL account and password but with the same result - The username or password is incorrect, yet this account works through SSMS and is able to execute queries and such.</p>
  
  <p>When i click the Test Connection button in SSRS datasource configuration, it states the connection was created successfully. (I have included a shot of what I am talking about in the uploaded image)</p>
  
  <p>After googling, people stated that the account that is being used to connect to the database using windows impersonation had to have log on locally permissions, so I added the account through local security Policy, but it made no difference.</p>
  
  <p>Another blog  stated the SSRS Service account had to also be granted log on locally permissions - so I granted it the log on locally permission as well. Still to no avail.</p>
  
  <p>I have also tried disabling the windows firewall and connecting to both the machine name and localhost just in case there was some screwy rules regarding localhost - still with the same result.</p>
  
  <p>Other people suggested the execution account in SSRS manager needed be disabled. I didn't set this up initially - but set the account up just in case it had something to do with it - still with the same error then removed it again still with the same error.</p>
  
  <p>Can anyone offer any other suggestions as to what might be the cause and how I might fix this?</p>
  
  <p>Many thanks and Cheers</p>
  
  <p>Rod.</p>
  
  <p><a href="https://i.stack.imgur.com/2auiS.png" rel="noreferrer"><img src="https://i.stack.imgur.com/2auiS.png" alt="enter image description here"></a></p>