Sql reporting service stopped unexpectly

Last Post 18 May 2009 06:09 AM by xcao. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
xcao
New Member
New Member

--
18 May 2009 06:09 AM
Hello,

Every Monday when I come to office We cannot connect to report server, I noticed the reporting service was down. Then I had to manually start it, then it works. All the weekdays it works OK.
The reporting service is setup for automatically restart. By looking at sql log, the sql server is not stopped and started during the weekend.

I don't know what happened during the weekend, but it seems it's an automatical thing, I checked th log in windows event viewer, all I found is a message: cannot connect to report server, I think that happens when we tried to connect to the report server, since it's down, it gives that message. So that doesn't help.

In SQL log, I can find an information message:
This instance of sql server has been using a process ID of 5920 since 5/4//2009. This is an informational message only, no user action is required.

What could be the problem? How can fix it?

Thanks
You are not authorized to post a reply.

Acceptable Use Policy