Re: PROBLEM WITH BCM AND SQL SERVER

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Try reposting this to microsoft.public.outlook.bcm as the people who actually use BCM hang out "down the hall."

--?
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, Hoser asked:

| 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.
.



Relevant Pages

  • PROBLEM WITH BCM AND SQL SERVER
    ... A problem with BCM started to occur on my computer recently. ... outlook I received an error message “BCM for Outlook could not connect to the ... When Trying To Start Sql server Through Computer Management I get ... 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)