June 16, 2015 at 9:18 am
Hoping you can shed some light, I have done a lot of googling on this and retesting but nothing is working quite right.
We have 2 new users to a Sales team. On Friday I gave them access to a report but they can't access it. They can access the folder itself but when they click on the direct link it comes up with the old favourite:
An error has occurred during report processing. (rsProcessingAborted)The permissions granted to user 'UserFred' are insufficient for performing this operation. (rsAccessDenied).
Their access is no different to anyone else in the same team. I have full administrative rights to SSRS and the machine it sits on. I have tried removing and re adding the access several times (even on the server itself instead of my local machine, with IE in administrator mode) to no avail.
Has anyone else had this at all? And if so how did you fix it?
Thanks in advance for your help.
June 16, 2015 at 1:49 pm
How are permissions on the report setup for the report data source(s)? If it is using Windows integrated security do the new users have access to the back-end data source(s)?
Joie Andrew
"Since 1982"
June 16, 2015 at 2:27 pm
Check whether the report is inheriting permissions from the parent, quite often people change individual permissions, which stops inheritance.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);June 17, 2015 at 1:19 am
Thanks both, the data source has its own id so that's fine.
It should be inheriting this from the parent folder but it's not. It's very odd as normally you can add the person to both the folder and report and this resolves this, but this isn't working for me.
Thanks for any further advice.
June 17, 2015 at 1:37 am
like mentioned before, if the SSRS end is ok, it's probably their permissions (or lack of) in SQL Server that's the problem
June 17, 2015 at 6:04 am
karen.blake (6/17/2015)
Thanks both, the data source has its own id so that's fine.It should be inheriting this from the parent folder but it's not. It's very odd as normally you can add the person to both the folder and report and this resolves this, but this isn't working for me.
Thanks for any further advice.
That raises more questions than answers for me....
So you seem to be saying that you added the user to the report permissions explicitly and they still go the error - is that right?
Can they access the "folder" that contains the report in the report manager?
if they can access the folder, does removing their permissions from the folder stop them accessing it (checking they are who you think they are)
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);June 17, 2015 at 6:59 am
That is correct, I went into Security on the folder settings as normal and added the user. They appeared in the Security of both yet he can click on the folder and he can go to it, but if he clicks on the report he gets the error.
I removed him from the folder and he got the error say he couldn't access the folder. I am just testing reading him to the folder again to see if he can go to it again.
Not had this type of thing before, am going to get him to try running IE in administrator mode but I know this doesn't usually sort the error he is getting.
Thanks for your help, this is a scratching the head one.
June 17, 2015 at 7:08 am
Have you checked permissions on the folder that contains your data source?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);June 22, 2015 at 2:17 am
Thank you Mr Magoo, gosh I am rusty!
June 22, 2015 at 1:50 pm
No problem, glad you solved it.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply