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
Anonymous comments are disabled
Page view tracker