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.
https://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.
Comments
- Anonymous
June 02, 2008
The comment has been removed - Anonymous
June 02, 2008
HiBy Office we mean Microsoft Office 2007 and not Office Accounting 2007/2008.ThanksVinit [MSFT] - Anonymous
June 19, 2008
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. - Anonymous
June 19, 2008
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?ThanksVinit [MSFT] - Anonymous
June 19, 2008
The comment has been removed - Anonymous
June 19, 2008
win2k above means windows 2003 server 32-bit. not windows 2000. sorry. - Anonymous
August 11, 2008
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 regardsErik - Anonymous
October 07, 2008
john.mahoney@stainlessllc.com email me. is the "Add new Group" functionality in Outlook 2007 applicable to BCM in any way?
- John M.
Anonymous
November 25, 2008
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."Anonymous
November 26, 2008
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]Anonymous
December 09, 2008
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.comAnonymous
December 09, 2008
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]Anonymous
December 10, 2008
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'.Anonymous
December 10, 2008
How are .sbb files restored? info@capitaltrainingresources.comAnonymous
December 18, 2008
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. KateAnonymous
December 24, 2008
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 helpAnonymous
December 29, 2008
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]Anonymous
February 11, 2009
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?Anonymous
March 20, 2009
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?Anonymous
March 30, 2009
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]Anonymous
April 22, 2009
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.Anonymous
May 08, 2009
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?Anonymous
May 14, 2009
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?Anonymous
August 13, 2009
How to filter contacts using fields of the connected account?Anonymous
August 13, 2009
How to add in the report programming fields?Anonymous
February 25, 2010
I was wondering if that document that outlines the workaround for getting the BCM Database Tool to work with 64-Bit SQL Server 2005 is still available. That link seems to be completely dead and I can't find that doc anywhere. Any help is appreciated!Anonymous
March 04, 2010
Hi, I had BCM 2007 running on a Vista machine with Office 2007. I installed Windows 7 on my machine and then installed Office 2007 with BCM 2007. I restored my BCM database by running Outlook as an Administrator and it all restored just fine. Now when i try to add/edit any account or contact, i get a message saying that The identifier for Business Contact manager databse has just been changed. Another user may have restored the database. Restart Outlook to connect to this database with the new identifier. I have resartd outlook several times but to no avail. Please help.Anonymous
March 05, 2010
Can I use the Database admin tool to host the database file on an SBS 2008 standard server? The server is 64 bit, does not have SQL on it, but could we put 32 bit SQL express on it and use the database tool? I do not want to start down this road if it will not work at all, but some of the things I have read lead me to believe I can do this on SBS 2008, just wanted to confirm. Thanks for any help. TomAnonymous
March 05, 2010
The sharepoint link above appears to no longer be valid. Can it be updated. Thanks TomAnonymous
March 09, 2010
The comment has been removedAnonymous
May 13, 2010
Hi, I used the Database tool to set up database on our SQL 2005 64-bit without problems, and accessed the database from clients with the Office 2010 Beta flawlessly. Then, after replacing the Beta version of Office 2010 with the recent RTM version I could no longer access the database. Neither could I backup, or create a new, database with the database tool on the SQL server (error message referring to a log file not exisitig). Trying to find a workaround I stumbled upon this page where the link, http://blogs.msdn.com/bcm/archive/2008/05/20/frequently-asked-questions-for-database-admin-tool.aspx, leading nowere. Could someone advice, please?Anonymous
June 23, 2010
I have installed the Business Contact Manager for Outlook 2007 Database Tool on my server and successfully shared the BCM database for the users. I can open the shared database from Outlook 2007 using the BCM wizard. I now must install the BCM client software on many more PCs that will also connect to the remote BCM DB. Because of this, I know I'll never need to use the local SQL 2005 Express DB on the PCs. I know I can simply disable those services on the PCs that I've already completed, but I was hoping to speed-up the process for the future PCs by skipping the SQL portion of the BCM install altogether. I cannot seem to find a method for this type of custom install of BCM. Does anyone know the procedure for installing BCM without installing a SQL instance?Anonymous
September 07, 2010
Tryiing to use the Business Contact Manager for Outlook 2010 Database Tool to update a BCM 2007 dafabase. It fails with the message "Migrating the database did not complete successfuily" There are no other errors or explanations, and nothing in the event logs. The database looks healthy in SQL Server Manager. Can you help me find what is going wrong? Thanks!Anonymous
October 19, 2010
I am unable to access the document link at the top of the document that talks about the workaround to installing on SQL 2005 64-bit. I get an Access denied error. Please help.