My PC Randomly Restarts - cause appears to be SQL 2005 & BCM Derek 11/27/2008 5:22:01 PM 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

Re: My PC Randomly Restarts - cause appears to be SQL 2005 & BCM "WhoisAaron?" <aaronshim[ at ]googlemail.com> 11/27/2008 5:51:59 PM On Nov 27, 5:22 pm, Derek <derek_...[ at ]yahoo.com> wrote: [Quoted Text] > 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 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/details.aspx?FamilyId=94C32ABF-5481-460D-805D-6C274AC1D194&displaylang=en Aaron

Re: My PC Randomly Restarts - cause appears to be SQL 2005 & BCM Derek 11/27/2008 11:47:02 PM 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 "WhoisAaron?" wrote: [Quoted Text] > On Nov 27, 5:22 pm, Derek <derek_...[ at ]yahoo.com> wrote: > > 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 > > 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/details.aspx?FamilyId=94C32ABF-5481-460D-805D-6C274AC1D194&displaylang=en > > > Aaron >

Re: My PC Randomly Restarts - cause appears to be SQL 2005 & BCM "WhoisAaron?" <aaronshim[ at ]googlemail.com> 11/28/2008 9:46:56 AM On Nov 27, 11:47 pm, Derek <derek_...[ at ]yahoo.com> wrote: [Quoted Text] > 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 > > "WhoisAaron?" wrote: > > On Nov 27, 5:22 pm, Derek <derek_...[ at ]yahoo.com> wrote: > > > 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 > > > 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/details.aspx?FamilyId=94C32ABF-548... > > > Aaron 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

Re: My PC Randomly Restarts - cause appears to be SQL 2005 & BCM Derek 11/29/2008 10:08:01 AM Good suggestion Aaron, I'll try this and let you know. Derek "WhoisAaron?" wrote: [Quoted Text] > On Nov 27, 11:47 pm, Derek <derek_...[ at ]yahoo.com> wrote: > > 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 > > > > "WhoisAaron?" wrote: > > > On Nov 27, 5:22 pm, Derek <derek_...[ at ]yahoo.com> wrote: > > > > 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 > > > > > 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/details.aspx?FamilyId=94C32ABF-548... > > > > > Aaron > > 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 >

Re: My PC Randomly Restarts - cause appears to be SQL 2005 & BCM Derek 12/1/2008 11:12:01 PM 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 "Derek" wrote: [Quoted Text] > Good suggestion Aaron, I'll try this and let you know. > > Derek > > > "WhoisAaron?" wrote: > > > On Nov 27, 11:47 pm, Derek <derek_...[ at ]yahoo.com> wrote: > > > 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 > > > > > > "WhoisAaron?" wrote: > > > > On Nov 27, 5:22 pm, Derek <derek_...[ at ]yahoo.com> wrote: > > > > > 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 > > > > > > > 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/details.aspx?FamilyId=94C32ABF-548... > > > > > > > Aaron > > > > 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 > >