Are you an Outlook 2007 with Business Contact Manager user? If you are, you might have experienced that the local SQL Server 2005 Express instance (named MSSMLBIZ) starts by default when your OS starts up. I found this to be quite annoying, because I don’t use BCM all the time. BCM will start the MSSMLBIZ instance if it’s stopped and the user navigates to a view where BCM data is required. That behaviour is completely sufficient and it seems pointless to start MSSMLBIZ at boot time. So, how to handle this issue?
Surprisingly, setting the start mode of MSSMLBIZ to Manual in SQL Server Configuration Manager does not change anything. After looking in the event log I realized that BCM comes with another service that handles SQL Server startup. The service is called Business Contact Manager SQL Server Startup Service (BcmSqlStartupSvc.exe). When you disable the automatic startup of this service, the OS boot time will return to normal and you will only experience a slight delay when you navigate to BCM data in Outlook, because from now on this will be the startup moment for MSSMLBIZ.