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:
我刚刚在运行Windows 10 Pro x64的笔记本电脑上安装了SQL 2012 Enterprise。当我尝试从报表管理器执行我的SSRS报表时，我总是得到同样的错误：
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
报告处理期间发生错误。 （rsProcessingAborted）无法模拟用户的数据源'DataSource1'。 （rsErrorImpersonatingUser）登录失败。确保用户名和密码正确无误。 （rsLogonFailed）用户名或密码不正确
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.
我正在使用域帐户的集成Windows身份验证。域帐户可以通过SSMS登录，并且可以无问题地访问数据库并运行查询。
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.
我也尝试使用本地SQL帐户和密码，但结果相同 - 用户名或密码不正确，但此帐户通过SSMS工作，并能够执行查询等。
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)
当我单击SSRS数据源配置中的“测试连接”按钮时，它表明已成功创建连接。 （我在上传的图片中包含了我正在谈论的内容）
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.
谷歌搜索后，人们说，使用Windows模拟连接到数据库的帐户必须登录本地权限，所以我通过本地安全策略添加了帐户，但它没有任何区别。
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.
另一篇博客表示，SSRS服务帐户也必须被授予登录本地权限 - 所以我也授予它本地登录权限。仍无济于事。
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.
我也试过禁用Windows防火墙并连接到机器名和localhost，以防万一有关于localhost的一些棘手的规则 - 仍然有相同的结果。
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.
其他人建议禁用SSRS管理器中的执行帐户。我最初没有设置它 - 但是设置帐户以防万一它与它有关 - 仍然有相同的错误然后再次删除它仍然有相同的错误。
Can anyone offer any other suggestions as to what might be the cause and how I might fix this?
任何人都可以提供任何其他建议，可能是什么原因以及我如何解决这个问题？
Many thanks and Cheers
非常感谢和干杯
Rod.
竿。
2 个解决方案
#1
2
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.
问题是Chrome和IE11在管理数据源时不会更新Reports网站。即使以管理员身份启动，SSRS管理界面也不会保存更改。边缘只是一个笑话，所以甚至不打扰那个。
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.
现在 - 我认为微软已经打破了Windows 10中SSRS界面需要的东西，所以我登录到Windows 7机器并使用IE11，能够导航到报表管理器站点，更新凭据（Windows和SQL Server凭据）和报告跑。
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.
通过尝试在Windows 10上更改凭据来确认这一点，并立即再次打破报告。在Win 7中重新设置凭据并更正报告。
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.
因此，如果您使用的是Windows 10并且在为SSRS报告配置凭据时遇到问题，请尝试从Windows 7计算机登录并通过该计算机上的IE进行设置。
EDIT: IE11 works on older windows 10 build (enterprise) , latest build (Pro) seems to be broken.
编辑：IE11适用于旧版Windows 10 build（企业版），最新版本（Pro）似乎被打破。
Cheers
干杯
Rod.
竿。
#2
0
If you have specified an unattended execution account, SSRS flip-flops between impersonating it and the identity specified in your data source during the rendering process. If you use an unattended execution account, you’ve got to keep the password up-to-date.
如果您指定了无人参与的执行帐户，则SSRS会在呈现过程中模拟它与数据源中指定的标识之间的触发器。如果您使用无人参与的执行帐户，则必须使密码保持最新。
You could also choose not to use the unattended execution account at all, which may also solve your problem. For more detail see http://blogs.msdn.com/b/bimusings/archive/2006/08/16/702490.aspx
您也可以选择不使用无人值守的执行帐户，这也可以解决您的问题。有关更多详细信息，请参阅http://blogs.msdn.com/b/bimusings/archive/2006/08/16/702490.aspx
#1
2
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.
问题是Chrome和IE11在管理数据源时不会更新Reports网站。即使以管理员身份启动，SSRS管理界面也不会保存更改。边缘只是一个笑话，所以甚至不打扰那个。
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.
现在 - 我认为微软已经打破了Windows 10中SSRS界面需要的东西，所以我登录到Windows 7机器并使用IE11，能够导航到报表管理器站点，更新凭据（Windows和SQL Server凭据）和报告跑。
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.
通过尝试在Windows 10上更改凭据来确认这一点，并立即再次打破报告。在Win 7中重新设置凭据并更正报告。
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.
因此，如果您使用的是Windows 10并且在为SSRS报告配置凭据时遇到问题，请尝试从Windows 7计算机登录并通过该计算机上的IE进行设置。
EDIT: IE11 works on older windows 10 build (enterprise) , latest build (Pro) seems to be broken.
编辑：IE11适用于旧版Windows 10 build（企业版），最新版本（Pro）似乎被打破。
Cheers
干杯
Rod.
竿。
#2
0
If you have specified an unattended execution account, SSRS flip-flops between impersonating it and the identity specified in your data source during the rendering process. If you use an unattended execution account, you’ve got to keep the password up-to-date.
如果您指定了无人参与的执行帐户，则SSRS会在呈现过程中模拟它与数据源中指定的标识之间的触发器。如果您使用无人参与的执行帐户，则必须使密码保持最新。
You could also choose not to use the unattended execution account at all, which may also solve your problem. For more detail see http://blogs.msdn.com/b/bimusings/archive/2006/08/16/702490.aspx
您也可以选择不使用无人值守的执行帐户，这也可以解决您的问题。有关更多详细信息，请参阅http://blogs.msdn.com/b/bimusings/archive/2006/08/16/702490.aspx