Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Report Manager Problem

Author  Topic 

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-14 : 05:57:40
Hi

I have just uploaded a report on to Report Manager. I can view it clearly on my pc, but when another person looks at it theor PC they get the following error:

'An error has occurred during report processing.
Query execution failed for data set 'UpcomingEvents'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors'

Does anyone know what the problem could be?

Thanks

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-14 : 06:20:59
Have you both got the same you user rights, are you both admins?
Go to Top of Page

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-14 : 07:29:42
I am the only one who is a admin
Go to Top of Page

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-14 : 08:32:08
Ok, its sounds like a permissions thing, that the other user does not have the correct access to see the report. I would check what users have what rights on what reports. Make sure that the user or group she is in has at least read rights to the report.
Go to Top of Page

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-14 : 10:07:03
I am using a stored procedure, would it work if I applied a Grant to Public Statement on the stored procedure?
Go to Top of Page

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-14 : 10:11:42
most likly, but you need to find out what users need what rights.
Go to Top of Page
   

- Advertisement -