we run ssrs 2005 sp2 hotfix applied - how do we troubleshoot a problem where the report server service is stopping unexpectedly several times a day. When this happens please tell me what happens to the reports that are currently running. I believe that
1) a current subscription that is running will fail - not sure if it will try to restart itself 3 times or not
2) connection to the report server db cannot be made when that occurs
this is a huge problem for us and we dont know what is causing it or how to fix it. Any suggestions would help. I can tell you that our customers flood the server with subscriptions
Hi,
You can find detailed informaion about the SSRS service in the log files at this location:
<drive:>\Program Files\Microsoft SQL Server\MSSQL.<n>\Reporting Services\LogFiles\
It should help to identify the problem.
Regards,
Janos
|||thanks - but I am already aware of the log files at that location and looking in them is not telling me the reason why the service is stopping unexpectedly. There isnt anything in the log file that I can see which would indicate that behavior.
Please ... if there is something I am missing that you are aware of ... a particular type of error that would cause the service to stop then let I would like to know about it. Thank you.
No comments:
Post a Comment