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.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2008-12-11 : 10:11:43
|
| Hi,All of a sudden, im creating reports and they run and work on my local machine when testing on visual studio, but when I deploy to the report server I get the following error:An error has occurred during report processing. (rsProcessingAborted)Query execution failed for data set 'DataSet2'. (rsErrorExecutingCommand)For more information about this error navigate to the report server on the local server machine, or enable remote errors For the new report, but when I re-deploy an old report seems to be working fine. Datasets same name, everything its not really making any sense.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-11 : 10:34:46
|
| are you using same datasource for new reports as well? what authentication do you use in datasource for connection? also do you have access to datasource? |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2008-12-11 : 10:49:23
|
Yes to same datasource, same authentication, and yes I do have access.quote:
Originally posted by visakh16
are you using same datasource for new reports as well? what authentication do you use in datasource for connection? also do you have access to datasource?
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 09:58:24
|
| are you using stored procedure or query as source of Dataset2? ALso does all objects like tables used in query are avialble under dbo schema? |
|
|
|
|
|
|
Wierd errors