I would REALLY appreciate any pointers here.
So I've set up a new SSRS 2008. It works fine for myself & other domain admins. I have 2 reports & need the following security set up:
Report 1 - visible by user 1 only (& domain admins)
Report 2 - visible by user 2 only (& domain admins)
But I set up user 1, and permissioned them in SSRS. I've added site settings = system user & system admin. & added them into all other folders. No matter what I do in here I get an SSRS error = "user x does not have required permissions. verify that sufficient permissions have been granted and windows UAC restrictions have been addressed".
What am I missing? Are there windows permissions user 1 needs. Or permissions within SQL itself?
This is doing my nut in. Thanks in advance.