Cannot find the object x because it does not exist or you do not have permission
I have a report which runs fine in BIDSI can run the proc ok, in BIDS and mgmt studioIt has identical permissions to other reports that have been deployed to the same folder and work ok.When clicking 'view report', processing appears to occur, then after about 20 seconds of watching the spinning lacanobia oleracea, I am presented with the following:An error has occurred during report processing. Cannot read the next data row for the data set ZZZZZZZ. Cannot find the object 'XXXXXXXXXXX', because it does not exist or you do not have permission. Why is it taking so long to fail?What other cause might there be?
July 30th, 2008 10:11am

Tried removing and recreating identical permissions, then received error 'dbo' user does not exist?!Deleted proc and recreated again using identical permissionsWorks fine
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2008 3:44am

Right click on the user at the server level -> User Mapping -> at the bottom "Database role and membership check on db_ddladmin -> OK you are good to go
September 18th, 2012 11:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics