MS CRM 1.2 crashing at least once a week

I have a SBS 2003 server running MS CRM 1.2, I am also running SQL on
the same server. At least once a week the CRM server will just stop
working, no services appear to fail, nothing seems to be out of the
ordinary. I will still get a login prompt if I try to access the CRM
page over HTTP. Once I enter my credentials it will just sit there
trying to load the page. It never times out and never gives me any kind
of error. The only thing I was able to pull out of the event log that
seems related is the following.

Source: SQLSERVERAGENT
Event ID: 208

SQL Server Scheduled Job 'Start_Incremental on
PAINCARE_INC_MSCRM.ftcat_documentindex.[7.5]'
(0x389D5EDE4AA55841BDACD758B09C19DC) - Status: Failed - Invoked on:
2006-01-16 13:45:00 - Message: The job failed. The Job was invoked by
Schedule 1 (Indexed Document Title Schedule). The last step to run was
step 1 (Full-Text Indexing).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

The only way I am able to bring CRM back online is to completly reboot
the server, I have tried restarting every service I can think of, and
resetting IIS. I am stumped. Any ideas? Taking down the server is bad
news since I am also running GreatPlains SQL info off the same server.

Not sure if this has anything to do with your issue, but are you running
Crystal reports? If you have the canned Crystal reports running it can cause
significant processor spikes and server response issues. I had to remove all
canned reports until I was able to place perameters on the ones with large
data set returns. If someone runs a Crystal report with a complex querry or
large data set return, it can drive up the processor and the processor does
not recover.


"defrag4@gmail.com" wrote:

> I have a SBS 2003 server running MS CRM 1.2, I am also running SQL on
> the same server. At least once a week the CRM server will just stop
> working, no services appear to fail, nothing seems to be out of the
> ordinary. I will still get a login prompt if I try to access the CRM
> page over HTTP. Once I enter my credentials it will just sit there
> trying to load the page. It never times out and never gives me any kind
> of error. The only thing I was able to pull out of the event log that
> seems related is the following.
>
> Source: SQLSERVERAGENT
> Event ID: 208
>
> SQL Server Scheduled Job 'Start_Incremental on
> PAINCARE_INC_MSCRM.ftcat_documentindex.[7.5]'
> (0x389D5EDE4AA55841BDACD758B09C19DC) - Status: Failed - Invoked on:
> 2006-01-16 13:45:00 - Message: The job failed. The Job was invoked by
> Schedule 1 (Indexed Document Title Schedule). The last step to run was
> step 1 (Full-Text Indexing).
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> The only way I am able to bring CRM back online is to completly reboot
> the server, I have tried restarting every service I can think of, and
> resetting IIS. I am stumped. Any ideas? Taking down the server is bad
> news since I am also running GreatPlains SQL info off the same server.
>
>