Welcome to MSDN Blogs Sign in | Join | Help

News

  • The views expressed in this blog are those of the individual and do not necessarily represent those of Microsoft. This information is provided by way of general information only and should not be relied on without obtaining independent expert advice. These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use
Frequently asked questions for Database Admin Tool

Can I set up a BCM database on SQL 2005 64-bit edition?

Database Tool is not supported on 64-bit SQL 2005.  However you can try a manual workaround by following the instructions in the document given bleow.

http://sharepoint.microsoft.com/innovateon/officedeveloper/Developer%20Documents/Outlook2007BusinessContactManager.doc

After deploying the database, how do I add and remove users?

The BCM database sharing wizard handles adding and removing users.

On the client side, BCM installs SQL Express even if you have no
 intention of using it. Is it necessary?  

It's not necessary to have sql installed on a client that will only
ever connect to a shared database on a server, but it is recommended to have it installed.

On our SBS server, I would like to change the location of the BCM database
files (MDF, LDF, BAK) to something other than the default "Application Data"
folder in "Documents and Settings".

Download SQL Management Studio from Microsoft Website (if it's not already on your SBS
server)Open SQL Management Studio, expand the Databases section in the left navigation   bar, right click on your database, choose Tasks > Detach.  To ReAttach, right click on Databases and choose Attach, then browse to the location of  the MDF file on your hard drive..

Need to setup Accounting 2008 Pro and Office 2007 Pro linked to
Business Contact Manager on Small Business Server.

Database Admin tool can help you setup database on your SBS server. Also you do not need Office installed on the SBS server.

Posted: Tuesday, May 20, 2008 2:01 AM by bcmteam

Comments

ToughD said:

I installed Office Accounting 2008 on my SBS box.  According to the last statement, "Also you do not need Office installed on the SBS server", I can remove Office Accounting 2008 from my SBS box?

Thank you.

# June 2, 2008 4:39 PM

bcmteam said:

Hi

By Office we mean Microsoft Office 2007 and not Office Accounting 2007/2008.

Thanks

Vinit [MSFT]

# June 2, 2008 4:47 PM

casaozeta said:

I am using Business Contact Manager (BCM) 2007. I have a shared BCM database on a Windows 2003 Server. That server's hard drive failed and the server needed to be rebuilt. I restored the BCM database to SQL Express 2005. Now in Outlook 2007 I am getting the error: "The identifier for the Business Contact Manager database has just been changed. Another user may have restored the database. Restart Outlook to connect to this database with the new identifier." Despite repeated reboots, I continue to get this error. I need to get this working. I have several users with many changes they have made to their local copy of BCM and those changes need to be sychronized with the restored BCM database on the Windows 2003 Server. Please help.

# June 19, 2008 4:09 PM

bcmteam said:

Please answer following questions:

1.“I restored the BCM database to SQL Express 2005.”  Can you please elaborate on this?

2.Was the backup taken on a different machine from the one on which the hard drive failed?

3.What format was the backup taken in? .bak or .sbb?

4.How did you restore the database- through BCM restore or using a SQL command?

Thanks

Vinit [MSFT]

# June 19, 2008 8:41 PM

casaozeta said:

The BCM database was originally on the win2k box with sql 2005 express.  after I removed the bad hard drive from the box, i installed a new hard drive, reinstalled win2k and sql 2005 express and used the Business Contact Manager for Outlook 2007 Database Tool to restore the database to the previous database name. it was an .sbb restore.  what does the error mean? what is this "identifier for the Business Contact Manager database". how do i fix it?  no matter how many times i reboot i get this error when I try to build the offline database.  it appears to work fine without an offline database, but we need the offline databases.  Thanks!

# June 19, 2008 8:52 PM

casaozeta said:

win2k above means windows 2003 server 32-bit. not windows 2000.  sorry.

# June 19, 2008 8:53 PM

Erik@MSDN said:

Anyone have a checklist/documents which shows steps to take to connect the local BCM-clients on the users machines to the common SQL database preferrably the SQL Express?

Also looking for documentation about what fields in the BCM-tabs (accounts, business contacts and opportunities) are adjustable and how this is done?

Kind regards

Erik

# August 11, 2008 11:48 AM

johnjm04 said:

john.mahoney@stainlessllc.com

email me.

is the "Add new Group" functionality in Outlook 2007 applicable to BCM in any way?

- John M.

# October 7, 2008 12:44 PM

Joe Cathey said:

When trying to back up the BCM database I get the following error message:

"Errors occurred during the back up of these files.  The backup process has stopped."

# November 25, 2008 7:52 PM

bcmteam said:

Hi Joe,

Can you please turn on BCM logging and post the logs here?

To enable logging, go to Help|About Business Contact Manager for Outlook. On the dialog check the enable logging for Business Contact Manager for outlook. Then go to your user profile Temp folder and look for BCMV3.log file.

Thanks

Vinit [MSFT]

# November 26, 2008 1:32 PM

CliftonGilchrist said:

I am having trouble switching the database over to a new host.  After I exported and imported everything, some opportunities are missing from the new host's database.  It's affecting my sales numbers for the year.

Any ideas on just exporting opportunities?

Thanks,

info@capitaltrainingresources.com

# December 9, 2008 3:22 PM

bcmteam said:

Hi Clifton,

Did you get any errors while exporting BCM data? If you did, can you check the logs and see what went wrong?

Thanks

Vinit [MSFT]

# December 9, 2008 5:55 PM

CliftonGilchrist said:

I read the log and it says that they were duplicate entries, however there are varying times as well as dollar amounts assigned to the "Closed - Won" opportunities.

It seems to not like to bring over closed out opportunities period.  We're missing some other records after I did the 'import and update'.

# December 10, 2008 4:08 PM

CliftonGilchrist said:

How are .sbb files restored?

info@capitaltrainingresources.com

# December 10, 2008 5:57 PM

mayfield said:

Hi BCM team

Can I clarify, can you install SQL express on any server and run the BCM database admin tool on that? Or does it have to be an SQL server? My client needs to move BCM off its SQL server and doesn't have another SQL server. They think they therefore can't host the database on any other server.

Kate

# December 18, 2008 8:10 AM

mkrtx said:

Hi folks - I am in process of migrating from windows xp to windows vista - i have a new laptop with vista running outlook 2003 - and do not have the old laptop which had XP

i am a heavy BCM user - so I did a "backup" from XP which created a .msbcm file

i have installed all the updates from "office update" - however, i did note it did not pick up SP4 for Outlook 2003 (KB930954)

the problem i am having is that the Import does not allow a selection of .msbcm, only .bcm

what are my options - i would be devastated to lose all that data

i also have a copy of the data on my palm 650 treo - i used chapura to sync - i have not synced that application to vista yet, so that might be an opportunity?

in advance, i appreciate any help

# December 24, 2008 1:09 PM

bcmteam said:

Hi,

.msbcm file is a database backup file so you'll need to restore on you new laptop and not import it.It should be under database tools.

let me know if this doesnt help.

Thanks

Vinit [MSFT]

# December 29, 2008 7:16 PM

jgs said:

Hi,

Every time I share a database with the database admin tool, I get the following message:

Business Contact Manager for Outlook 2007 Database Tool:

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

The system cannot find the file specified.

It is followed by a list of details when I click on details. Then I click continue, and everything seems to be okay.

Is this something I need to worry about?

# February 11, 2009 4:29 PM

sreames said:

I am trying to install DB Admin Tool on Windows Server 2003. It asks for me to choose an SQL instance, and the only one to choose from is a pre-existing HP Web Jet Instance. Do I need to reinstall something or does selecting this SQL instance mess up the Web Jet SQL db?

# March 20, 2009 5:44 PM

bcmteam said:

Hi Sreames,

If you don't want to use the existing instance, you can download the free sql 2005 express edition, create a new sql instance, and use that instance instead.

Hope this helps

Thanks

-Vinit [MSFT]

# March 30, 2009 2:26 PM

garyleaf said:

We purchased a Windows Home Server for backup purposes.  Works great for that.  Now my wife wants me to create a Business Contact Manager Database on the WHS and make it accessable via remote login over the Internet.  Is this even possible?  I've spent hours searching for a similar question and have found nothing.  If it can be done, I will need a detailed step-by-step how to.  Glad to do that offline if necessary.

# April 22, 2009 5:32 PM

DPFS said:

The previous post response said:

"After deploying the database, how do I add and remove users?

The BCM database sharing wizard handles adding and removing users."

However I do not see a way to delete or remove users with the database admin tool on  the machine that is hosting the database?  Am i missing something?

# May 8, 2009 7:54 PM

Trent said:

Found the question below previously in this string (dated Jan. 19, 2009 - now seems to have disappeared) but saw no responses.  I have the same issue with BCM 2007 - need to include Opportunity Notes in a report - can this be done? Here's the previous question:

I am using 2007 BCM and am trying to create opportunity reports.  It seems that opportunity notes from the details window are not available in the reporting options.  So I want create custom reports using Access through an ODBC connection to the BCM database.  Then I decided to include the user defined fields I have created but can not find what table that data in these fields is located.  All I can find is the table with the field definitions but not the data fields.  Can any one help?

# May 14, 2009 8:59 AM

Lev_Bondarenko said:

How to filter contacts using fields of the connected account?

# August 14, 2009 2:03 AM

Lev_Bondarenko said:

How to add in the report programming fields?

# August 14, 2009 2:05 AM
Anonymous comments are disabled
Page view tracker