PROBLEMS WITH BCM AND SQL SERVER - PLEASE HELP

[Hoser]

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

 

[Hoser]

VERY DISAPPOINTED AT THE DISTINCT LACK OF RESPONSE. STARTING TO WISH I HAD
NOT PAID SO MUCH FOR THE SOFTWARE. I PRESUME THAT THIS IS A KNOWN FAULT AND
NOBODY AT MICROSOFT WANTS TO ADDRESS THE ISSUE?

 

[Joepie]

VERY DISAPPOINTED AT THE DISTINCT LACK OF RESPONSE.  STARTING TO WISH IHAD
NOT PAID SO MUCH FOR THE SOFTWARE.  I PRESUME THAT THIS IS A KNOWN FAULT AND
NOBODY AT MICROSOFT WANTS TO ADDRESS THE ISSUE?

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

I had enormous problems with BCM under Office 2003. With 2007 it works
just fine. I can't do much with the rest of your information I'm
afraid. Can't remember anyone ever asked to show them. Did you do all
the usual tricks? Did you remove the SXL server as well under
'software'? Maybe you should also reinstall Outlook? I can remember
that BCM uses all sorts of files on the harddisk. Did you remove the
maps of BCM under Documents and Settings? You could even throw out all
occurrances of BCM in the registry, although that can be tricky. So,
DON'T FORGET TO BACKUP BEFORE YOU DO ANYTHING.
Probably you have done all this. I understand your desperateness. This
newsgroup isn't very active I'm afraid. BCM is not very popular.

 

[Luther]

VERY DISAPPOINTED AT THE DISTINCT LACK OF RESPONSE.  STARTING TO WISH IHAD
NOT PAID SO MUCH FOR THE SOFTWARE.  I PRESUME THAT THIS IS A KNOWN FAULT AND
NOBODY AT MICROSOFT WANTS TO ADDRESS THE ISSUE?









- Show quoted text -

If you want help from Microsoft, contact Microsoft suport. This is a
public forum for BCM users.

 

[pianoguy]

I have exactly the same problem.
After installing XP SP3 yesterday the SQL server service for BCM 2007
will no longer start.
Tried to do a repair BCM from the original CD's but it failed.

Even worse, backup is not possible when the SQL server is not running.
Of course I can backup the data files (.ldf and .mdf), but my
experience is they are useless. BCM is very restrictive and it is very
difficult to make it accept files from another installation.

Actually there was problems installing XP SP3 (stopped with "Access
denied") and therefore I had to run a special script made by microsoft
to modify some user rights in the registry and windows system files
(see http://support.microsoft.com/kb/949377). After that XP SP3
installed without problems. Unfortunately BCM stopped working instead.

Hoser, did you find a solution to the problem? - or anyone else with
ideas what to do?

Thanks.

 

[Luther]

I have exactly the same problem.
After installing XP SP3 yesterday the SQL server service for BCM 2007
will no longer start.
Tried to do a repair BCM from the original CD's but it failed.

Even worse, backup is not possible when the SQL server is not running.
Of course I can backup the data files (.ldf and .mdf), but my
experience is they are useless. BCM is very restrictive and it is very
difficult to make it accept files from another installation.

Actually there was problems installing XP SP3 (stopped with "Access
denied") and therefore I had to run a special script made by microsoft
to modify some user rights in the registry and windows system files
(seehttp://support.microsoft.com/kb/949377). After that XP SP3
installed without problems. Unfortunately BCM stopped working instead.

Hoser, did you find a solution to the problem? - or anyone else with
ideas what to do?

Thanks.

My guess is that SP3 changes some permissions and the account that SQL
was running with can no longer access some files so it shutdown. There
are probably messages in the Windows event logs about the error. If
not, its possible that the sql service's login doesn't even have
permission to start the service.

You could try setting the sql service for the bcm instance (something
like MSSMLBIZ) to the administrator account, and see if it run with
that.

 

[pianoguy]

My guess is that SP3 changes some permissions and the account thatSQL
was running with can no longer access some files so it shutdown. There
are probably messages in the Windows event logs about the error. Ifnot, its possible that thesqlservice's login doesn't even
have permission to start the service.
You could try setting thesqlservice for thebcminstance (something
like MSSMLBIZ) to the administrator account, and see if itrunwith
that.

In the "SQL Server Configuration Manager" I already tried to change
the logon for MSSMLBIZ from "Build-in account: Network Service" to my
own administrator account, but it would still not start.
However, now that I read your suggestion, I tried to go to
Administrative Tools - Services and change the logon information there
- and then I was allowed to start the service :-D

Thanks for leading me on the track.