I think I'm finally beginning to figure this out, but I need some assistance please. When me and my coworkers attempt to run a standard SSMS report (Disk Usage by Top Tables, etc.) in the Object Explorer / Object Explorer Details, we get the below error.
Almost every Google response to this error is related to SSRS (Reporting Services), not SSMS. The one link I did find recommended rebooting the server. Didn't work. I have found, however, that our server admin accounts (different from our usual logins) CAN run these reports on the server or in an SSMS window that has been opened up using that account. The difference is that our admin accounts have special login privileges on the servers while our usual login accounts are essentially locked out of direct / remote server administration permissions. Both accounts are members of the SysAdmin role on SQL Server. So that is not the issue.
This tells me the error is related to an OS level or SAN level permission problem. The question now is, which permission?
I tried granting Read & Execute to our normal logins on the folder where the report .dll files are located, but no joy. Still running into this error with our regular logins. Does anyone have any suggestions as to what server (not SQL Server, actual server) permissions are needed to run these reports?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.