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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2009-07-01 : 20:16:42
|
| We have Reporting Server which constitutes the functionality of monthly processing, which happens 2 days in month and other reporting structures being executed all other times during this Monthly processing.While this Monthly Processing is executed with the help of some Stored Procedures, but during this Monthly Processing is going on the Reporting Department cannot access data for reporting purpose.I am not sure what is causing to stop this reporting when this Monthly processing is going on.I am sure that there is no such statement in the Monthly processing which stops OR interrupts other reporting structure.I have even checked those Logins which do the reporting structures were not disabled either.Everything seems to be ok, but only hurdle is when Monthly processing is going on, there will not be any access for the reporting by reporting department.Can anyone help me in this regard?Many thanks for your time and advise. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-02 : 02:46:46
|
quote:
Originally posted by dbalearner
We have Reporting Server which constitutes the functionality of monthly processing, which happens 2 days in month and other reporting structures being executed all other times during this Monthly processing.While this Monthly Processing is executed with the help of some Stored Procedures, but during this Monthly Processing is going on the Reporting Department cannot access data for reporting purpose.I am not sure what is causing to stop this reporting when this Monthly processing is going on.I am sure that there is no such statement in the Monthly processing which stops OR interrupts other reporting structure.I have even checked those Logins which do the reporting structures were not disabled either.Everything seems to be ok, but only hurdle is when Monthly processing is going on, there will not be any access for the reporting by reporting department.Can anyone help me in this regard?Many thanks for your time and advise.
you get errors, time outs...please elaborate |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-07-08 : 18:13:29
|
| I have narrated the error part in the first place.Can anyone has got any answer.Thanks |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-09 : 03:34:43
|
quote:
Originally posted by dbalearner
I have narrated the error part in the first place.Can anyone has got any answer.Thanks
well....your problem description is not descriptive enough to workaround."Reporting Department cannot access data for reporting purpose"this may mean a security issue..blocking issue....I advise you to run profiler to trace the issue |
|
|
|
|
|
|
Reporting Problem