报告/查询不会在某些用户帐户下返回 [英] Report / Query won't return under some user accounts

问题描述

访问2007前端，SQL Server 2008 R2后端，Windows 7客户端计算机


对于一些更复杂的报告/查询，前端将锁定并且永不返回某些用户的任何内容，但会在几秒钟内返回给同一台计算机上的其他用户。无论他们去哪台计算机，都会发生这种情况。 SQL Server上的不同用户的权限看起来相同。我唯一能想到的是某种错误配置的用户特定设置，它被复制到域中的计算机上。但我不知道这个设置甚至可能是什么。有没有人经历过这个？或者对可能导致它的原因有任何其他想法？

Access 2007 front end, SQL Server 2008 R2 back end, Windows 7 client computers

For some of the more complicated reports / queries, the front end will lock up and never return anything for some users, but will return in a few seconds for other users on the same computer. This happens regardless of which computer they go to. Permissions look the same for the different users on SQL Server. The only thing I can think of is some sort of misconfigured user specific setting that''s replicated to the computers from the domain. But I have no idea what this setting could even be. Has anyone experienced this? Or have any other ideas about what might be causing it?

推荐答案

您是使用Windows身份验证还是SQL用户登录SQL服务器？

Are you using Windows authentication or SQL users to sign into the SQL server?

Windows身份验证

Windows authentication

用户可以通过SSMS运行查询吗？

Can the user run the query through SSMS?

这篇关于报告/查询不会在某些用户帐户下返回的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！