I just installed SQL 2012 Enterprise on a laptop running Windows 10 Pro x64. When I try to execute SSRS reports from Report Manager, I always get the same error:
An error occurred while processing the report. (RsProcessingAborted) Cannot impersonate user for data source "DataSource1". (RsErrorImpersonatingUser) Login failed. Make sure the username and password are correct. (RsLogonFailed) Invalid username or password
I am using Integrated Windows Authentication with a domain account. A domain account can register through SSMS and can access databases without problems and run queries.
I also tried using the local SQL account and password, but with the same result. The username or password is incorrect, but this account works through SSMS and can fulfill requests, etc.
When I click the Test Connection button in the SSRS data source configuration, it indicates that the connection was created successfully. (I included a snapshot of what I say in the uploaded image)
After googling, people said that the account that was used to connect to the database using Windows impersonations had to register at local permissions, so I added the account using the local security policy, but that didnβt matter.
Another blog post states that the SSRS service account must also be provided to log in to local permissions - so I also gave it local permission. Still to no avail.
I also tried disabling the Windows firewall and connecting to both the machine name and the local hosting just in case there were any creepy rules regarding localhost - still with the same result.
Other people suggested that the execution account in SSRS Manager be disabled. I did not ask this at first, but I set up an account just in case, if it had anything to do with it - still with the same error, and then deleted it again with the same error.
Can anyone suggest any other suggestions as to what could be causing and how can I fix it?
Many thanks and greetings
Rod
