My PC Randomly Restarts - cause appears to be SQL 2005 & BCM

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

I have a really annoying PC problem that appears to be caused by Business
Contact Manager and Outlook 2007. With Outlook running in the background, I
could be working with Word, Excel (or any other application) when suddenly
the PC freezes and then I get the black restart screen.

By right clicking on My Computer and then selecting the Event Viewer /
Application, I can see the events leading up to the restart - it's always the
same sequence i.e. a number of entries made by MSSQL$MSSMLBIZ with messages
like "datbase mirroring transport is disabled or not configure" and "The
Service Broker protocol transport is disabled or not configured".

Can anyone here help?
Thanks,
Derek
 
I have a really annoying PC problem that appears to be caused by Business
Contact Manager and Outlook 2007. With Outlook running in the background,I
could be working with Word, Excel (or any other application) when suddenly
the PC freezes and then I get the black restart screen.

By right clicking on My Computer and then selecting the Event Viewer /
Application, I can see the events leading up to the restart - it's alwaysthe
same sequence i.e. a number of entries made by MSSQL$MSSMLBIZ with messages
like "datbase mirroring transport is disabled or not configure" and "The
Service Broker protocol transport is disabled or not configured".

Can anyone here help?
Thanks,
Derek
Click to expand...

The SQL instance could be accessing more memory than your PC would
normally use, and therefore triggering the reboot. Run some hardware
diagnostics, most notably on the RAM (memtest is very good).

I would also make sure you have Office SP1, BCM SP1 and all SQL
patches installed.

BCM SP1 - http://www.microsoft.com/downloads/...BF-5481-460D-805D-6C274AC1D194&displaylang=en


Aaron
 
Appreciate the response Aaron, I have 4GB RAM and have already run memtest
and the RAM passed all patterns. If it was a RAM problem then other
applications would probably fail as well, but they don't. Processor is a
Q6600.

The problem has a very consistent profile which is focused on SQL 2005 and
MSSQL$MSSMLBIZ, it's always the same shutdown pattern.

Thanks,
Derek
 
Appreciate the response Aaron, I have 4GB RAM and have already run memtest
and the RAM passed all patterns.  If it was a RAM problem then other
applications would probably fail as well, but they don't.  Processor isa
Q6600.

The problem has a very consistent profile which is focused on SQL 2005 and
MSSQL$MSSMLBIZ, it's always the same shutdown pattern.

Thanks,
Derek
Click to expand...

Have you tried exporting your data, then creating a new BCM database?
This is quite a simple process.

Good processor by the way - My test machine uses the same.


Aaron
 
Aaron,

Well done, I was looking for a complicated solution but it turns out that
all I had to do was to re-index the database. I did export and back up the
data as a precaution but it wasn't necessary to rebuild with an import. The
error messages have now stopped in the application log and the PC is now
stable.

My only issue is why should a database error cause the PC tp restart? I
though the so called "blue screen of death" had been banished, but apparently
not. I'm using the latest version of XP Pro with SP3. Anyway, main thing is
the problem's gone away. Aaron, thanks again for your kind support.

Derek
 
Back
Top