PROBLEM WITH BCM AND SQL SERVER



A problem with BCM started to occur on my computer recently. When starting
outlook I received an error message “BCM for Outlook could not connect to the
shared database. Do you want to work offline?”
I tried to uninstall and repair BCM with Disk 2 but now it fails to install
and gives the following error message “Setup failed to install Business
Contact Manager for Outlook 2007. See C:\Documents and
settings\Administrator\Local Settings\Temp\MBSetuptmpA3.log for more detail.”
I have worked through the help at
http://office.microsoft.com/en-us/outlook/HP011128601033.aspx and appear to
have a problem with the SQL server

When Trying To Start Sql server (Mssmlbiz) Through Computer Management I get
the following error:
“Windows could not start the SQL Server (MSSMLBIZ) on Local Computer. For
more information, review the System Event Log. If this is non-Microsoft
service, contact the service vendor and refer to specific error code 3417.”
These are the last two entries of the event log:
Event Type: Error
Event Source: MSSQL$MSSMLBIZ
Event Category: (2)
Event ID: 9003
Date: 19/08/2008
Time: 23:17:24
User: N/A
Computer: SAS_MASTER
Description:
The log scan number (230:152:1) passed to log scan in database 'master' is
not valid. This error may indicate data corruption or that the log file
(.ldf) does not match the data file (.mdf). If this error occurred during
replication, re-create the publication. Otherwise, restore from backup if the
problem results in a failure during startup.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 2b 23 00 00 14 00 00 00 +#......
0008: 14 00 00 00 53 00 41 00 ....S.A.
0010: 53 00 5f 00 4d 00 41 00 S._.M.A.
0018: 53 00 54 00 45 00 52 00 S.T.E.R.
0020: 5c 00 4d 00 53 00 53 00 \.M.S.S.
0028: 4d 00 4c 00 42 00 49 00 M.L.B.I.
0030: 5a 00 00 00 00 00 00 00 Z.......
Event Type: Information
Event Source: MSSQL$MSSMLBIZ
Event Category: (2)
Event ID: 3417
Date: 19/08/2008
Time: 23:17:24
User: N/A
Computer: SAS_MASTER
Description:
Cannot recover the master database. SQL Server is unable to run. Restore
master from a full backup, repair it, or rebuild it. For more information
about how to rebuild the master database, see SQL Server Books Online.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 59 0d 00 00 0a 00 00 00 Y.......
0008: 14 00 00 00 53 00 41 00 ....S.A.
0010: 53 00 5f 00 4d 00 41 00 S._.M.A.
0018: 53 00 54 00 45 00 52 00 S.T.E.R.
0020: 5c 00 4d 00 53 00 53 00 \.M.S.S.
0028: 4d 00 4c 00 42 00 49 00 M.L.B.I.
0030: 5a 00 00 00 00 00 00 00 Z.......

Can anyone tell me how to restore BCM given the above? Thank you.

--
Thanks
.



Relevant Pages

  • Re: PROBLEM WITH BCM AND SQL SERVER
    ... Try reposting this to microsoft.public.outlook.bcm as the people who actually use BCM hang out "down the hall." ... Milly Staples [MVP - Outlook] ... | When Trying To Start Sql server Through Computer ... | information about how to rebuild the master database, ...
    (microsoft.public.outlook)
  • Re: Outlook Business Contact Manager
    ... BCM works differently than Outlook (although from the outside it looks ... Data is stored in a MSDE (a version of SQL Server ... database) databae dedicated to BCM. ...
    (microsoft.public.outlook.contacts)
  • Outlook BCM Install failed
    ... Outlook 2007 with BCM, which failed. ... The error string said: The SQL Server ... Am I OK to install BCM onto Outlook Enterprise, and if so, what appears to ...
    (microsoft.public.outlook.installation)
  • RE: Contact manager installation
    ... Subject: Contact manager installation ... As you are only using POP3 account, there is no matter which BCM version you used. ... follow the steps below to reinstall the .NET framework to see if it works. ... It is mostly caused that the BCM is disabled in Outlook or BCM is not added in Outlook. ...
    (microsoft.public.outlook.installation)
  • RE: Endpoint Mapper issues
    ... a Windows Small Business 2003 environment. ... to share the BCM database. ... I'd like to know whether you installed Outlook and BCM on the SBS server. ...
    (microsoft.public.windows.server.sbs)