BCM 2010 and a shared BCM 2007 Database



  • 1. MSSMLBIZ is not holding BCM data
    Upgraded from windows xp office pro 03 with BCM to office ent 07 with bcm on single user laptop The following is listed as an instance for SQL Express, if I disable it, I no longer have access to my BCM contacts in Outlook O7 SQL Server (MSSMLBIZ) However, when I upgrade from 03, I was using a BCM date file of MSBUSINESSCONTACTMANAGER, which in outlook, File, Datafile Management, it shows BCM 07 is using MSBUSINESSCONTACTMANAGER, but MSBUSINESSCONTACTMANAGER does not show up under Computer, Manage, Serices as MSSMLBIZ does. Obviously, the one that is being used should be in both MSBUSINESSCONTACTMANAGER and under services and I should be able get rid of the instance of MSSMLBIZ (which is not listed as in use under BCM datafile management). So, I know MSSMLBIZ is the default, should I somehow merge data from MSBUSINESSCONTACTMANAGER into it, or what is going on? Thanks! bob
  • 2. Outlook Web Access
    I use Outlook Web Access to access my work email remotely. Is there an update or option to allow access (R/O or R/W) to my BCM data ?
  • 3. BCM on SQL is very slow on SBS
    I convinced a group of 6 people to share a bcm database on our small business server. I'm using sql express on the SBS until I can install r2. I have noticed a considerable speed issue on computers since installing the shared BCM. I've bumped the laptops to 2gb of ram to handle it but it's still slow. Furthermore the "check for errors" on the database management screen is greyed and I cannot check that. do I need to improve the performance of my server to handle this? Is there a tool to manage and speed up the database?

BCM 2010 and a shared BCM 2007 Database

Postby RGF2ZQ » Fri, 20 Nov 2009 02:03:01 GMT

I can't find any information on if a BCM 2010 client can access a shared 
database created by the BCM 2007 shared database tool. Our how the migration 
process will work for people moving from BCM 2007 to BCM 2010.


Re: BCM 2010 and a shared BCM 2007 Database

Postby Sun Embraser » Fri, 20 Nov 2009 18:28:08 GMT

Hi, after installing BCM 2010, existing BCM 2007 database (running in
SQL Server 2005 Express) will be migrated to SQL Server 2008 Express
From that point on, all shared clients will need to be using BCM 2010
to connect to that database... meaning you will want to upgrade all of
your shared environment to Office 2010 + BCM 2010 if you choose to use
Office 2010.
Of course, before upgrading, backing up your data (either through
"Backup" or "Export") is strongly recommended.

Re: BCM 2010 and a shared BCM 2007 Database

Postby kchieff » Mon, 23 Nov 2009 00:56:36 GMT

It's unlikely that you'll be able to revert your data back to BCM 2007
if you choose not to move ahead - I would not move my production
database to 2010, I would copy it and try it, knowing that I may lose
any changes that I made should I decide not to move everyone to 2010.

On Thu, 19 Nov 2009 01:28:08 -0800 (PST), Sun Embraser

Re: BCM 2010 and a shared BCM 2007 Database

Postby RGF2ZQ » Tue, 24 Nov 2009 13:29:01 GMT

Thanks guys.

Ok I get that I won't be able to share a database with 2007 and 2010 
clients. But our database is on a server that does not have outlook or BCM 
installed. It was created using the shared database tool.

So I would like to take our shared db on SQL 2005 and copy it to SQL 2008 
and convert for BCM 2010 to test but can't find an documentation or the 
shared db tool for BCM 2010.


Re: BCM 2010 and a shared BCM 2007 Database

Postby RGF2ZQ » Tue, 24 Nov 2009 13:33:01 GMT

OK I just saw the post with the tool and it says you can backup and restore 
your 2007 db to a sql 2k8 server so I'll give it a try and see how it goes.


Re: BCM 2010 and a shared BCM 2007 Database

Postby Sun Embraser » Tue, 24 Nov 2009 18:52:48 GMT

kchieff is right.  There is no option in BCM 2010 to let you go back
to the 2007 database format once you move forward.  Back up data is a
good idea.  Use a test environment is also a good idea, if you can
affort the extra hardware or have virtual machines for this.

Dave, please do let us know if your experiement works out.  I saw the
same post too, and they say BCM 2010 works with SQL 2005.  I guess if
you have SQL Express 2005, upgrading to SQL Express 2008 should be a
good idea, but if you have any other version of SQL 2005 (that you
paid for), the BCM team is thoughtful enough to not force you to
upgrade to SQL Express 2008 - that you can keep using SQL 2005.


Similar Threads:

1.Missing contacts and Opportunities in BCM 2010 Shared database

We have the RTM of BCM 2010 installed and are using a shared database located 
on a SQL server.  Up until yesterday the database functioned fine, all users 
had no issues with seeing contacts, opportunities, accounts etc.  Today, all 
users are missing some contacts, and about half of the opportunities.  I have 
logged into the SQL server using Management Studio and have opened the tables 
and all of the data is still in the database.  None of it is listed in the 
deleted tables. But the records wont all show in BCM on the client.  I have 
tried both with offline enabled and with it turned off.  Still missing.  I 
can not see any rhyme or reason to the disappearances.  

I originally set this shared database up manually since the BCM admin tool 
wasn't available.  Yesterday, it became available and  i downloaded and 
installed it on the server.  Just to check functionality, i ran the tool, but 
made no permission changes at all to the database.  I thought that this may 
be the problem, so i restored the database from the backup that we ran 
tuesday night.  No go, the contacts and opportunities still do not show up in 
the clients.  But the data is present in the tables.  Any one have any ideas?
Russell Reid

2.BCM 2010 error creating offline copy of shared database

We have deployed our BCM 2010 database (RTM not beta) to a SQL server to 
share the database amongst several users.  We can successfully connect to the 
database from client machines.  And the user access works (create, save, 
edit, etc).  But when we try to create an offline copy of the database on the 
client we get the error 'Business Contact Manager for Outlook could not 
complete your last action or actions.  Please try again.'  The client sql 
server service is running.  I can find no event log entry that gives me a 
clue to the problem.  This has happened on two different machines.  Both are 
using the Office 2010 RTM with BCM 2010 RTM.  The shared database is the same 
version as the clients.  Does any one have an indication of what could be the 
Russell Reid

3.Connecting BCM 2007 to a shared BCM 2003 Database

4.Upgrade OL 2007 BCM to OL 2010 BCM Beta

I am in a real bind.  I loaded Office Pro Plus 2010 (Beta) which installed 
fine and running well.  My problem is trying to load in BCM.  I have 
attempted at 8 times and nothing...I have sent frowns to support and to the 
blog but I have not received a response.

The reason I am in a bind - as a condition of upgrade the OL BCM 2010 
installation deletes 2007 BCM.  I can't get 2010 installed and I don't know 
that I can reinstall 2007 BCM which I don't really want to, because I am 
anxious to work with 2010 because of all the new features.  In fact I was 
briefy with another CRM software, however, when I saw all the new features of 
2010 I thought I would go back.

This has not been a pleasant experience because it appears the BCM Team is 
responding to others but not my requests for assistance.

If you can suggest how I can get this issue resolved I would be greatly 
appreciative.  I do not have access to my data and it is hurting my 

Thanks for listening and I hope to God I can get someone to help!


5.Can I share BCM V2 Database on 2003 by using BCM Data Admin Tool

I created a BCM database in my local machine and I would like to move it to 
the server so other machines on the network can have access to it as well. I 
used osql -E -S command to stop the BCM database from my machine and moved it 
to the server, and I re-attached BCM database from the server. 

EXEC sp_attach_db @dbname = N'STS_Config', @filename1 = 
N'C:\new_database_location\STS_Config.mdf', @filename2 = 

Can I have other machine attach to the Database in the server the same way? 
Since I am the owner, I still have to give permission to user to access it. 
But I would rather perfer to have Admin on the server have the total control 
of DB. It seems MS2007 BCM Data Admin Tool is the way to go, but does it work 
on the database created by BCM V2 on MS2003? 

I installed the BCM Data Admin Tool + SQL 2005 Express, when I launch the 
Admin Tool it did not find the BCM Instance, is there a special way to 
configure that?

Any help will be greatly appreciated.

6. BCM 2010 - database problem



Who is online

Users browsing this forum: No registered users and 93 guest