I have two SBS 2003 sites that have recently both stopped
sending reports. No changes were made to cause this. The
scheduled tasks run, but the emails are not sent. The
data is processed as you can view the report in the
Server Management Console.
I have done the "Reinstall Monitoring" option which made
no difference. I have tried internal addresses as well
as the previous addresses, no luck. The SMTP log is not
showing any attempt to send, so I assume the app that
processes the reports in not even getting to the stage of
emailing.
If I manually go into the Server Management and tell it
to "Send Now" it still doesn't work.
Anyone got any idea. All SQL services are running. I
have had a cryptic error in the App log to do with it, as
follows - Event id 1
Server Status Report:
URL:
http://localhost/monitoring/perf.aspx?reportMode=0
Error Message: Timeout expired. The timeout
period elapsed prior to completion of the operation or
the server is not responding.
Stack Trace: at
System.Data.SqlClient.SqlCommand.ExecuteReader
(CommandBehavior cmdBehavior, RunBehavior runBehavior,
Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader
(CommandBehavior behavior)
at
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.Ex
ecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand
(Object data, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
dataSet, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet
dataSet)
at usage.frmPerf.populateErrorLogs(ServerInfo si)
at usage.frmPerf.populateServerList()
at usage.frmPerf.renderReportWorker()
at usage.frmPerf.renderReport()
Ta
Jeff