How to fix rsLogonFailed error message when executing report

Question

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:

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

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.

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.

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)

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.

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.

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.

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.

Can anyone offer any other suggestions as to what might be the cause and how I might fix this?

Many thanks and Cheers

Rod.

Answer 1

OK - managed to work out the problem and a workaround. But it doesn't actually solve the problem.

Problem is Chrome and IE11 wont update the Reports web site when managing datasources. Even when launched as administrator, the SSRS management interface site does not appear to save the changes. Edge is just a joke so don't even bother with that one.

Now - I figured Microsoft has broken something which SSRS interface needs in windows 10, so I logged onto a Windows 7 machine and using IE11, was able to navigate to report manager site, update the credentials (windows and SQL Server credentials) and the reports run.

Confirmed this by trying to change the credentials back on windows 10 and it immediately broke the reports again. Set the credentials back in Win 7 and it corrected the reports.

So if you are using windows 10 and are having issues configuring credentials for SSRS reports, try logging in from a windows 7 machine and set through IE on that machine.

EDIT: IE11 works on older windows 10 build (enterprise) , latest build (Pro) seems to be broken.

Cheers

Rod.