October 20, 2008 at 1:24 pm
Hello to all
I've a great problem, We have a RS2005 in Server 2003 with this DB in other server with SQLServer2005, We published a report in this RS server, with DataSource conexion in SQLServer2000 SP2, I and the publishers can run the reports, but a user can't, I've put to him the all privileges in DB Server, his domain group has a Browe permission in RS, He see the report, but when he want to run this report this show the next error
Error al procesar el informe.
Error de ejecución de consulta para el conjunto de datos 'Consultas'.
Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
The 'Consultas' is a dataset of the report, are there someone that can help me.
Thanks :w00t:
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
October 20, 2008 at 1:43 pm
Could you or someone translate the error message to English?
I think it says that the execution of the dataset failed because it couldn't connect and that by default SQL Server 2005 does not allow remote connections. If you are able to run it from the report server then it is a permissions issue. What are the credentials for the dataset?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 20, 2008 at 2:33 pm
the message say some this
Failed to process the report.
Error executing query data set for 'consultas'.
For more information about this error, go to the report server on the computer's local server, or enable remote errors
I hope that this was util
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
October 20, 2008 at 2:43 pm
It really sounds like a permissions error to me. Can the users who cannot run the report run the query directly using SSMS or Access?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 22, 2008 at 11:02 am
how I mentioned before, I put all priviliges to this user (sysadmin) and anyway don't run, thanks
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
October 22, 2008 at 11:19 am
Try adding this one user in a form of a DOMAINNAME\USERNAME to RS (in IIS) as a browser.
October 23, 2008 at 2:20 pm
best but is funcional, add de user in a Group Domain, to this group I gave rol of sysadmin in DB 2000 with danywrite in all Database, to the urgency the soluciton was this, anyway I will continue to look for more solutions when I have time, thanks to all, someone tell me how close this event, thanks again
Angel Miranda Nieto
DBA Specialist, BI, MCSA SQL Server
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply