November 1, 2010 at 5:57 am
I have an issue where i have a report pubished in Reporting Services 2008 that a user logged into with a login that isn't valid for the report. This is normally fine but the credentials have been saved and keep giving the error "The permissions granted to user '<DOMAIN>\<user>' are insufficient for performing this operation. (rsAccessDenied)".I have tried clearing down all saved passwords cookies etc. from IE but i still can not enter the details for the correct user.
Any ideas where this information is stored as i am having issues finding an answer to this.
November 1, 2010 at 6:25 am
Rather than trying to fetch the data using the logged in user's autherntication, you can basically use a SQL server login. But the report viewing can be restricted assigning proper roles to the end-users. Hope this helps in some way.
Regards,
Pravasis
November 1, 2010 at 8:30 am
Yeah i see what you are saying but it isnt giving me the option of entering a different user. The only way i have found of doing it so far is to reset the users password which then after a delay once active directory replicates i can then enter the correct user. However i have a number of sites with this issue and i dont want to have to do this fr every one of them. If i could work out how this user is stored locally and clear it down that would be a better solution for me.
November 1, 2010 at 10:51 pm
Basically, what I meant is to use a connection string something like "Data Source=ServerName;Initial Catalog=DBName;user=UserName;pwd=Passowrd;". The user name provided should have the required access to fetch the data from the table or execute the required SP. Or else in the report manager you can set the service account to execute the reports which will have access to the database. So, the users will be authenticated just to view the reports. If we are using the AD authentication for viewing the reports as well as fetching tha data then, just in case the user does not have a valid access to database he will not be able to view the reports. Hope its clear now.
Regards,
Pravasis
November 2, 2010 at 5:54 am
does the report use an embedded data source or separate SSRS stored data source? How is this data source configured?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2010 at 7:46 am
Its using an SSRS datasource calling a stored procedure.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply