BCM for Outlook 2010 Database Tool is live!


I’m pleased to report that the Business Contact Manager Database Tool, also known as the DB Admin Tool, is live:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=5f83d55e-1cc5-49dd-9b5f-06a7c08c00c2

Thanks all for your patience as we get things squared away!

Chris

Comments (84)

  1. jim says:

    when are you going to address single user licensing, or is Microsoft just going to pretend it doesn't hear all the noise from thousands of frustrated users?

  2. Tiendq says:

    Thanks, can I download BCM 2010 as a standalone installation package too?

  3. JB says:

    Awesome.  Thanks for the tool.  Is there a x64 version of the tool or will this work on a x64 version of SQL 2008?

  4. bcmteam says:

    Hi JB,

       This tool itself supports sql 2008 x64 version. Thanks.

  5. Mitch-vH says:

    BCM does not appear to support deployment to a remote named instance of SQL Server. Actually, to be more specific, this tool will create the database fine within a SQL instance, but the client can't seem to find the shared remote BCM database. Based on a network trace, the Manage Databases BCM wizard in the Outlook client appears to only connect and enumerate databases in the default SQL instance on the server (it also appears to do this in a totally bizarre way).

  6. Craig S says:

    How about adding a full tutorial for BCM 2010?

  7. PK@ltl.uk.com says:

    We are small company of 12 users and would like to share contacts, calenders etc thro BCM.

    Do you have How to guide for installing and configuring BCM.

  8. PK@ltl.uk.com says:

    We are small company of 12 users and would like to share contacts, calenders etc thro BCM.

    Do you have How to guide for installing and configuring BCM.

  9. tomk says:

    Where can I get support for this tool.

    I have SQL 2008 SP1 and using this tool, I get "An error occurred while creating a new database name."

  10. tomk says:

    Where can I get support for this tool.

    I have SQL 2008 SP1 and using this tool, I get "An error occurred while creating a new database name."

  11. Jerry [msft] says:

    Hi Tomk,

    We have seen that error before, and it has appened because there were either two instances of the tool running, or bcm was also running when trying to do the configuration.  We found if you close all instances of the tool, using task manager to make sure all instances are closed, then rerun it, it should work.

    Mitch-vH

    After you created the database with the tool did you then share out the database with the tool?

    –Jerry [msft]

  12. BertSP says:

    I am trying to install the BCM database on a SBS 2008 with sql 2008 r2 expressx 64 and get the " database name error" . will this run with sql2008 x64?  will this database be accessible remote to outlook 2010 using outlook anywhere (http/rpc) or any other transparent system (non-VPN)?

  13. Mitch-vH says:

    Jerry;

    I don't recall sharing it as a separate step, but I did specifically give users access to the database – so I think it was shared. I have subsequently put it on another server in the default instance, using same set of steps and it worked fine.

    BertSP;

    I don't think what you are trying to do is possible. BCM communicates directly with the database server – it will not piggy back on the Outlook Anywhere rpc over http trick – at least, not that I have seen and some server setup would be required for this to work. You could expose the SQL Server to the internet directly on a non-default port – but I wouldn't recommend it – especially, given what you are exposing…

  14. Rich says:

    Hi,

    We have an SBS 2008 that I have installed the BCM 2010 tool on successfully, I have then created a database and shared it with users, this seemed to work fine.

    Then on the Win 7 Client machines running Office 2010 with BCM 2010 I can input the SERVERNAME/SQLEXPRESS,-1 as given in the text file results of the BCM 2010 tool but only to get the error message that the Server is found but there are no BCM databases on it?

    I tested with the server firewall switched off but I don’t know how to find the problem, the instruction given by the BCM 2010 tool are very limited and as it’s so new there aren’t many posts anywhere.

    Anyone know what I’m missing?

    Cheers

    Rich

  15. Rubin Rodriguez says:

    Can't get the BCM to install. windows 7, 64 bit, Office 2010 Pro Plus.

    after restart and booting up the system error of

    BCMSetup.en-us spawncmd.js

    No application is associated with file for the operation.

    What is the problem? I deleted the SQL 5 and reinstalled the BCM, but still no good same error.

    Rubin

  16. Ron Anderson says:

    It seems as if the functionality to customize forms is lost when using the BCM Tool. The server is the owner, so none of the outlook clients and edit or create forms. Is there a fix for this?

  17. John [msft] says:

    Ron,

    The customizer needs to be the DB admin or DB owner.  If you give database ownership or the SQL admin permission to your users (through SQL), your users can then do customization.

    Hope that helps,

    John [msft]

  18. nakul says:

    can this tool be used in task scheduler to backup the database automatically?

    i am aware of the script as back, but this would be a more robust way of doing that.

  19. Can someone please tell me how on earth to share a calendar in BCM?  I am totally lost.  I am using BCM 2010, no Exchange server

  20. FJB says:

    This really sucks that Microsoft is not offering BCM with a single user license.  I will not buy Office 2010 because of this. Microsoft if you can't offer continuity with Office than forget it.

  21. Jeff Langford says:

    The database tool will not install on Windows 7 x64. Upon running, it installs .NET SDK 1.1! What? Then nothing happens. There are no errors or anything–the installer just quits. I need to install this on my existing SQL 2008 so that multiple users can use the database. Please help…

    Thanks.

  22. Jack says:

    Can anyone speak to the performance (speed) of BCM 2010?  Our experience with past versions was it was slow. Specifically, when clicking on History it would take 50 secconds and longer to get the history.

  23. Mark Adkins says:

    Tool doesn't work for some things.   We were able to setup our database on a SQL Server 2008 machine and connect to it over VPN from a single Outlook profile.  But, we can't share it with other profiles.  When we use the BCM tool to Share the database, we receive an error that "Cannot find the database names for the selected SQL Server instance.  Please make sure the database service is running."    We setup the database using the default mssmlbiz name and the port is correct and everything.  No idea what's up with this..

  24. Jerry [MSFT] says:

    Hi Mark,

    Are you running the db tool on the machine you have sql installed on?  Or you trying to run it remotely?   If remotely, do you have TCP/IP turned on in sql, and your firewall is opened on the sql port for both the client, and the server?

    –jerry [MSFT]

  25. Alan Wong says:

    I have similar problem with Rich and Mark about share the database. BCM 2010 cannot find the database at SBS2008, even disabled the firewall. Any insight?

  26. Paul Fox says:

    I was using BCM with the Office 2010 Beta, I uninstalled downloaded the 2010 60 Day Demo which says it has BCM 2010 but alas, it's not there.  Was it pulled from the demo, or is there a separate process to install?  I can't find any documentation on this issue.  Thanks.

  27. Jerry [MSFT] says:

    Alan and Rich

    Can you connect to the shared db from sqlcmd on one of the client boxes?  When you said you disabled the firewall, was that on the clients too?  Is the user you are logged in on the client boxes, a shared user in the bcm database?

    –jerry [msft]

  28. c.lastres says:

    If we are using BCM with a remote database, can SQL Server Express 2008 be removed from the client PC's?

  29. Beau says:

    I'm having problems with the BCM database tool.  I am also receiving the database name issue.  In addition, when I try to create the database, I get the following error:  "Cannot create a new database. The operation has been rolled back. Please make sure the database service is running."  I'm trying run the tool on a clustered SQL Server 2008 box.  Any links to some documentation?

  30. KHowland says:

    c.lastres

    as long as you do not allow it to make a copy of the remote database you can uninstall sql locally.

    alan wong. rich and mark.

    you must indicate the location of the remote database in the proper format

    dbservernamedatabaseinstance

    ie.    

    bcmserverbcmdatabase

    i noticed someone using the forward slash… this wont work.

  31. Laura G. says:

    Seems that my last post didn't, well, post.  Again …

    I have a volume license for Office 2010 STD, with BCM 2010.  I downloaded both and installed them.  So far, so good.  Then, I went to access my local copy of our server's BCM and was told that, since it was created by an earlier version of BCM (duh!) I would need to use the BCM database tool.

    That's all fine and well, but the database tools did not install and the download linked to in the first post downloaded what was ostensibly the tools, file named for the tools, but upon double-click to install, it installed that file but that file happens to have been Bing Maps 3D — go figure!  Now, I'm trying to figure out how MS managed to mix this up.  I really need this tool but can't seem to find a proper copy of it.

    Does anyone have a clue?

  32. Chisholm says:

    I have downloaded trial of Office 2010 Pro Plus.  Had to install my Office 2007 Pro w BCM to get Outlook 2010 to work.  Now I do not have BCM and have lost all my very important BCM contacts, notes, everything.  What do I do?  Where can i download BCM 2010.  

  33. Chisholm says:

    My mistake. "I had to UNINSTALL Office 2007…)

  34. I'm getting super frustrated trying to find BCM to download. I have office professional, but I was using BCM with 2007 and now that I"ve upgraded to 2010 Office in anticipation of the 'great functionality' I'm stranded with no way to access my BCM database. I have tons of info in there, I need BCM, what do I do? PLEASE HELP!

  35. jimd says:

    I too am having the same problems as Rich, Mark and Alan.

    We have a Windows XP 32Bit virtual machine setup as our BCM db server but we cannot connect to the database from any other computers as it tells us it cannot find any databases on the computer.

    We actually have the same VM working with BCM 2007.

    We have tried using SQL Express 2005 as well as SQL Express 2008 R2 with the same results.

    The install of the SQL servers went without a hitch and it created the default instance 'SQLEXPRESS' We then installed the BCM 2010 Tool and created the db and then shared it while adding a user with a temp password.

    At the first attempt of trying to connect to the db, a message will appear telling us that the user must login with the same credentials that is used on their local machine. It then lets us change the password on the BCM server. After this, point we get the message saying it could not find a database on the bcm server PC. All subsequent attempts take us straight to this error message.

    I cannot find any sort of detailed documentation or even a simple document regarding the BCM DB Admin tool. I also wanted to post this problem on the BCM Support Forum but that site has been down for weeks and even when it was up, very very few posts even got a single answer back from Microsoft.

    Is Business Contact Manager actually supported by Microsoft? Seriously. If so, where does someone actually go for help?

  36. Rick Wolf says:

    I have tried numerous times to convert a BCM database created in 2007 into 2010 using the BCM for Outlook 2010 Database Tool.  It appears to be processing fine and at the end I receive an error message saying the conversion did not complete properly.  I do not believe the file is corrupted, but it is large, over 400,000 KB.  

    Is this error common and what can i do to convert the data so I run my small business on the new platform?

  37. kflorian says:

    Can BCM 2010 and Accounting Professional 2009 co-exist on the same SQL 2008 install?

    I understand that these products no longer integrate but can they co-exists?

    If so, what do I need to do to continue to use AP 2009 standalone while upgrading BCM to 2010?

    Thanks,

    Ken

  38. kante1luv says:

    I had Issues with installation, uninstalled, reinstalled, almost pulled my hair out.  I finally found the BCM program file which has a read me file in it which has some pretty good instructions on trouble shooting.  Best.

  39. kante1luv says:

    I am a college student, I would like to configure BCM 2010 for my job search.  I work, play sports, volunteer, and I'm taking a full load.  Can anyone direct me to a resource on using this as a job search tool?  Thank you in advance.

  40. Jean says:

    Hi guys,

    I'm trying to install the database tool in French to be able to share French BCM DB but I'm not able to do it. each time I launch the installer BCM2010-ServerWizard-x86-fr-FR.exe, I get an error "failed to install package".

    The installation works fine with the BCM2010-ServerWizard-x86-en-US.exe but then I'm not able to open the created and shared databases with my french outlook.

    I haven't found any reference at this issue in the web, that's why I publish here.

    Do you have any idea ? or any web site I can consult to get more details on that?

    Cheers

  41. Jason says:

    We are running sbs 2008, which uses SQL express 2005 for SBS monitoring etc.  I have successfully installed BCM 2010 onto a client workstation running Windows 7 Professional.  However, like many posted here, when i use the DB admin tool to connect to a remote database – it says that the database cannot be found (even though i can plainly see it).  Through reading other blogs, im told that its because BCM 2010 needs an instance called MSSMLBIZ for BCM to work – this instance IS on the windows 7 client workstation, but not on the SBS server – ive used MSMONITORING instance to run it.  Question is, how to i add an instance onto SBS 2008 so that i can put in MSSMLBIZ without affecting the current SQL databases on SBS 2008 that look after my backup and monitoring?  Additionally, does BCM 2010 require SQL 2008?  If so, will that hinder the SQL express 2005 software already on my server.  BCM does seem  a good product, but to be honest will all this hassle im not sure its actually worth it.

  42. Nicolas says:

    I had the same issue as Jean (2 posts above).

    So to test, I tried to use the German Package and it works perfectly. So I guess there is a specific issue on the French package. We need to wait for an update from MS.

    In my case, I tried to install the database tool in a Win Server 2008 R2 which is using SQL Server 2008 R2. My computers clients are in Windows 7 but I haven't any issue with BCM product on client computer.

    HTH

  43. Scott says:

    Can people with Office 2010 Home and Business 2010 (including Outlook) use BCM or must they have either Office Standard 2010 or Professional Plus 2010?

  44. nanosciguy says:

    Ive been using two licenses of Outlook 2007 with BCM since 2008 for my business. I want to upgrade to Office 2010, but apparently will sacrifice BCM fucntionality unless I buy a volume license (5 licenses minimum). This doesn't make sense. I'm looking for solutions. Suggestions?

  45. audin says:

    Hi there, here is our setup:

    2 Windows XP-x86 SP3 with Office prof. 2010 for partners (boot are Domain-members)

    Windows Server 2003 R2 64bit (DomainController)

    But we use Exchange online (microsoftonline.com) with the live-Sign in Tool

    We have problems to connect to the database, no SQL-Instance available…

    Witch credentials use the BCM to connect to the Database?

    does it use the Domain-logon-Credentials or the Credentials from microsoftonline.com (Live Sign In Tool)???

    If i am right, then the Live Sign In tool bend the credentials-mechanism. So that the login-data from this tool is used for RPCoverHTTPS and not the domain-logon-credentials.

    Could this be the reason that we can't connect to the Database, because the BCM-Database @ the Windows 2003 R2 DC estimate the Domain-Credentials?

    service@duessel-it.de

    thx

    audin

  46. flatline says:

    Hi there,

    I would like to know, how to defrag a remote BCM-Database. I migrated our old bcm-20007-db towards 2010-db using the database-tool.

    Database is running on a server without Office/Outlook-Client installed. i also tried starting outlook with the user-credentials used for bcm-database-ownership on the client side. But there is still no posibility to defrag the database.

    The Button just stays grey and unklickable.

    Thanks in advance

  47. Krikay says:

    I just received Office Pro 2010 and realized Pro Plus is only allowed in volume?  So small business users who want a Pro version of office have to give up BCM?  isnt BCM for the small biz??  This does not make sense!

  48. divine.living says:

    Hi… I am creating a report and there is no 'middle' name field. This field is critical for Spanish Speaking contacts.  Where can I post a suggestion that this field be added?  Frankly why are not all the fields on this report?  It would seem logical to not only have the custom fields, but have all the fields where data is being entered.

    Thanks

  49. Chris says:

    What good is it if we can't actually buy it!

    And no, spending $2,500 to buy 5 full licenses of Office 2010 is NOT a solution!!!

  50. chefmkc says:

    Gentlemen – for the single user -Home Office Outlook 2010 with BCM is not an option as MS has made it a 5 user license. This is not right I have been using it for many years! I most recently wanted to utilize the quote feature integration with MS Accounting Express that was free – and only found 2009 n CNET site. Called MS to find out it’s all discontinued!

    Then in the BCM version 2007 unless you can find a copy of MS Accounting 2008 you can’t convert an opportunity into a quote – and if you did you are paying $130 just for 1 feature so for all of the 1000s of Remote outside Sales Execs…. this is CRAZY!

    We all use Outlook and we all need to quote products and there are all of these CRM apps designed with Exec mngmt in mind – not the guys that actually sell something! VERY FRUSTRATING

    So if you know of a simple tool or MS 2007 – template – integration to put that “COVERT” to quote button and may this automated that would be great.!

    Or if you can answer that the MS Accounting 2009 express – with the SQL SP3 will work or something please let me know ASAP!

    Mahdi.1959@hotmail.com

  51. chefmkc says:

    Gentlemen – for the single user -Home Office Outlook 2010 with BCM is not an option as MS has made it a 5 user license. This is not right I have been using it for many years! I most recently wanted to utilize the quote feature integration with MS Accounting Express that was free – and only found 2009 n CNET site. Called MS to find out it’s all discontinued!

    Then in the BCM version 2007 unless you can find a copy of MS Accounting 2008 you can’t convert an opportunity into a quote – and if you did you are paying $130 just for 1 feature so for all of the 1000s of Remote outside Sales Execs…. this is CRAZY!

    We all use Outlook and we all need to quote products and there are all of these CRM apps designed with Exec mngmt in mind – not the guys that actually sell something! VERY FRUSTRATING

    So if you know of a simple tool or MS 2007 – template – integration to put that “COVERT” to quote button and may this automated that would be great.!

    Or if you can answer that the MS Accounting 2009 express – with the SQL SP3 will work or something please let me know ASAP!

    Mahdi.1959@hotmail.com

  52. DWang says:

    Does anyone know where I can find techinical documentation on configuring BCM 2010 database? I need to be able to justify why we need to setup another instance called MSSMLBIZ on our SQL box, but all I can find are blog posts.

    Any help is appreciated.

  53. Kr0ss says:

    For those of you having trouble connecting to the remote instance, i'd recommend reading through the following article.

    support.microsoft.com/…/953745

    In my case, it was the SQL Listening port that wasn't configured (at all).

    Check the port that the Business Contact Manager instance is listening on

    Verify which port the instance of SQL Server is listening on and whether it is enabled. To do this, follow these steps on the Business Contact Manager server:

    Open SQL Server Configuration Manager.

    Expand SQL Server 2005 Network Configuration, and then click Protocols for MSSMLBIZ.

    Double-Click TCP/IP.

    On the Protocol tab, verify that Enabled is set to Yes.

    Click the IP Addresses tab, and then verify that IP ALL is configured for TCP port 5356. If the port is set to a value except for 5356, you can either change the port to 5356, or choose to keep the one that is currently set. If you have to use a port except for 5356 in order to avoid a conflict with another program that uses this port, follow the steps in the section "Use a non-standard port or instance name"

    If it is necessary, change the port to 5356 and stop and restart the Business Contact Manager instance as prompted.

  54. GerSch says:

    When is coming Business Contact Manager 2010 Add-in for Pocket PC? For Windows Mobile 5/6.x and/or Windows Phone 7?

  55. Ginger9991 says:

    Hi Guys,

    I have been trying to upgrade BCM for days. Its the Migration which is the issue. Its from 2007 to 2010. It just fails to migrate. (migration unsucessful). I have tried this from the server and from the client and both dont work. I took a copy of the log below. The error pointed me towards SQL so i increased the file size and choose unrestricted growth but it still fails….HELP!

    insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    Could not create constraint. See previous errors.

    The statement has been terminated.

  56. John M says:

    We are migrating from BCM 2010 Beta to Office 2010 RTM .

    I've installed fresh copy of WinXP Office2010 & BCM2010. I can see the remote instance of the BCM 2010 (BETA) Database file, however its greyed out. Do I need to down load and install the latest Database Admin tool and Do I need to migrated that file from a "BCM 2010 BETA" File to BCM2010 RTM file?

    Please help us all to understand this..

    Thanks

    JM

  57. Jerry says:

    Hi John,

    Can you turn on logging and post the log from the client trying to connec to the beta database?  If you want to create RTM dbs, you will need the new vesrion of the admin tool.  Is the user which is trying to connect to the beta db an user in the database?  

    –Jerry Msft  

  58. Nicolas36260 says:

    I guess it is worth sharing my own experience. As most of you here, installation went smoothly but I could not connect to BCM. Using sqlcmd was a must to troubelshoot. Beware of syntax. It is sqlcmd -e -SserverNamebcminstanceName,port

    Port for BCM is 5356. Then I doscovered that even on the local server I could not connect to the instance. Then I opened Sql Server Configuration manager, went to SQL Server Network Configuration/Protococols for my BCM Instance name. Went to TCP/IP (make sure it is enabled) then went to IP Addresses, make sure then IP All TCP Poirt is set to 5356 (it is not by by defauklt). Close, restart service. Bingo! Installation details :

    – server : SQL server 2008 express r2, english, x64

    – BCM server x86, french

  59. mccartjt says:

    Jerry

    I uninstalled the beta database manager and then installed the new 2010 BCM database manager on my SBS2003 server. That server for the record was running SQL 2005 Express. (I've not bothered to upgrade it to SQL 2008 Express. ). Once the database manager was installed there's an option to migrate the old database, ( to a new format). I did the migration then from my client workstation with a new installation of Office/BCM 2010 RTM, I then ran the wizard to connect to the remote database. After this process I could see the migrated<changed> file.  So I connected and made a local back up copy of the database file on the client workstation and finally my major client is good to go! Yippee!! This stuff works!

    One thought that has struck me since the debacle/ hesitancy of MSFT not fully supporting BCM2010. There have been no books published on how to optimize/use/enhance one's BCM installation. This is sad because its a great little program. Given time small companies become larger and will necessarily need to a more robust product over time (Microsoft Dynamics)..

    JM

  60. Jerry says:

    JM,

    I am happy to hear your issue as been resolved.

    –Jerry

  61. mccartjt says:

    Jerry

    I have a crazy situation, going on. I have a small network of 5 machines that I have to migrate from Office 2010 Beta to RTM. I've just uninstalled BCM Beta 2010 (I left SQL 2008 Express) installed. then I uninstalled Office 2010 Beta. I rebooted. I then installed Office 2010 RTM and then BCM RTM. Now I can't find BCM? How crazy is that? I have run the repair process too and I still can't find BCM2010 RTM! Any ideas? I've searched this entire blog and come up with no ideas.

    Thanks for your support here..

    JM

  62. Jerry says:

    JM,

    Check the disable addin list in outlook, outlook could have disabled it for some reason.  You would find the disable items by going to Backstage->Options->Add-ins.  At the bottom of the page there is a drop down listed with the label "Manage:"  Select disabled items and click go.  If BCMMS32.dll is listed there, just re enable it.   That should do it.

    –jerry [msft]

  63. mccartjt says:

    Jerry

    This is just a note to thank you for helping me find the instance of BCM 2010 which had disappeared. Your suggestions were absolutely spot on target now I am fixed!

    Now that I have posted the word disappeared and BCM hopefully Bing & other search engines will spyder this blog and hand out these answers to everyone.that may run into the same issue.

    Thanks again

    JM

  64. VolLicOption says:

    volume license doesn't have to be 5 licenses of office Pro – you need 5 qualifying nodes to create a volume license

    it can be 1 x office pro plus to get bcm and 4 x office mobile cheapest SKU at around £5 each – we learnt this trick from an MS disti!!!

  65. René says:

    @Beau 30 jun 2010

    Same issue here with a clustered SQL2008R2 server.

    I noticed that the tool tries to place the database files in the appdata folder from the logged on user folder. Ofcourse this folder is not available as a resource in the cluster.

    Let's hope a more sophisticated tool will be available soon.

  66. NLS says:

    Seems to work fine on my SQL 2008 R2.

    I need an explanation of the database roles because I need to allow my users extra things. Where can I find this?

  67. NULUSIOS says:

    Well on one of my users it says it cannot connect because of an unknown external error! No specific error code or anything. Then BCM itself crashes (on the user).

    Talking about using a shared database made by the tool.

    It used to work one day before.

    Any ideas?

  68. Dan Eggert says:

    I used the database tool to create a SQL Server database instance on SQL Server 2008 SP2 – and have added the users.  I can connect users to the instance – a problem with re-importing the local databases back into the remote database has been encountered.

    The name of the contact is missing – it appears that all fields are shift by one field, as the Title information is found in the name field, etc.  Hoping that there is some guidance on this issue.  Is there a different schema in the database tool vs the BCM 2010 software itself.

    Your help is greatly anticipated.  Thanks!

  69. Ken Florian says:

    Not sure where else to ask this question is is so esoteric at this time:

    I want to upgrade to Office / BCM 2010. I am running BCM 2007 fine on SBS 2008 / SQL 2008 (running on the second server permitted by SBS 2008 Premium).

    Unfortunately, I am also committed to continuing to run Accounting Professional 2009 which is no longer supported by MS.

    My question is:  Can I run BCM 2010 AND continue to use Accounting Professional 2009 as SEPARATE apps/databases.  I fully understand that if I go with BCM 2010 that I can no longer integrate BCM data with Accounting 2009 data.    Can the two apps / databases co-exist on one server?

  70. Jerry says:

    Hi Ken Folrian,

    Yes, BCM 2010 and Acounting Professional 2009 will co-exist.  They will work on thier own, but you won't be able to connect the two together.

    –Jerry [MSFT]

  71. Patrick says:

    I have a question and I’m not sure where to ask it, but here goes.

    We have Outlook 2007 and plan to start using BCM.  We are concerned about the 4GB limit for Sql Express 2005, the free version that came with BCM.  How many contacts should we expect to put in our database before having to worry about the size limit?  Our contacts would contain the usually items, name, company, e-mail address, address, phone numbers, some custom fields and be associated with some accounts.

    We have only found a few people that posted on the internet how large their database was in relation to the amount of contacts they have.

    Thank you,

    Patrick

  72. max connection says:

    Hi, we are using outlook 2010 and bcm 2010, share a database from win2003 srv with bcm tools installed.

    The sync is so slow , what is the minimum hardware requirements and max connection to the server?

    I think we are using the db come with bcm tools, sql 2005 msde?

  73. Hello,

    i would like to send massive email with a marketing campaign.

    but for this i have to send only 1 packet of 10 email every minute due to my ISV.

    how to do ?

    I have to install Exchange ?

    Thanks for your help

  74. Raul says:

    Jerry (hope you are still around)

    We have a PC with XP SP3 (and the rest of the requirements) setup as our BCM db server but we cannot connect to the database from any other computers as it tells us it cannot find any databases on the computer, even when it was "shared" with the BCM database tool.

    We have tried using SQL Express 2005

    The install of the SQL servers went without a hitch and it created the default instance 'SQLEXPRESS' We then installed the BCM 2010 Tool and created the db and then shared it while adding a user with a temp password.

    At the first attempt of trying to connect to the db, a message will appear telling us that the user must login with the same credentials that is used on their local machine. It then lets us change the password on the BCM server. After this, point we get the message saying it could not find a database on the bcm server PC. All subsequent attempts take us straight to this error message.

    If I try connecting from SQL express from my laptop to the BCM server it does the connection.

    Hope to get some help, I cannot find any other information from Microsoft about this topic.

    Thanks

  75. James Wilcox says:

    Does anyone know what the ActivitiesAdditionalPropertyBag is for and what is it used for?

  76. I have BCM installed on a SQL 2008 SP2 instance shared throughout our office (4 clients). We use linked email tracking as well as contact synchronizing to our Exchange contact list.

    Im noticing extremely high batch counts against our SQL server (Upward of 400-800 a second). These occur only when Contact Synchronization is turned on. I'm seeing the following calls:

    exec ir_GetContactProperties

    Followed by

    exec ir_GetActivityProperties

    It seems that BCM is constantly syncing and re-syncing contacts. What would cause this to constantly be running? If one client changes a contact, does that signal to all other systems to resync the whole list?

    Any insight would be appreciated!

    Thx

  77. Janos Kreis says:

    Hi

    @Ryno1234: can you tell me which minimum rights the users need to have on the sql server ? Only being public is not enough to connect to the database. setup will tell you: no databases available. if i put the user in sysadmin, the user can see and connect to the created database. But, do I really need to give the user sysadmin rights ? Thx for a reply. Greetz Janos

  78. Sarven says:

    Hi,

    I have an installation of BCM on Win 7, i'm trying to connect to database that is located on SBS 2011 x64, I use the BCM Database tool, chose SBSMONITORING as Database Server Instance, then MSSmallBusiness, then shared with users but for some reason I always get no shared database on selected server, port 5356 is opened on both client and server (InBound / OutBound).

    I'm out of idead, PLS HELP!

  79. Krister Renaud says:

    Is SQL Server Express 2012 not supported by the tool? When running the tool it complains that no instances of SQL Server can be found.

  80. Krister Renaud says:

    SQL Express is not the problem. I installed a full SQL Server 2012 and the tool still complains.

    SQL Server is installed and listening on port 5356, the firewall is configured, SQL Management Studio can access the server instance. Yet, the tool complains that it cannot find any instances of SQL Server. I have the same problem on Server 2011 SBS Essentials and a W7 Ultimate I used as reference. Any suggestions on how to remedy this?

  81. BCM2010 SP1 will not install says:

    running BCM2010 on Win7 64bit OS  with Outlook2010 installed as 32 bit,  I have tried to install both the 32 & 64 bit versions of the SP1 with no success.  suggestions please

  82. caresrg says:

    I have been using BCM for Outlook 2010 (32-bit) on my standalone Windows 7 PC. Because my automatic backup has been backing up my entire user folder, including AppData, I assumed that my BCM data was being backed up. Until my hard drive crashed. I've been rebuilding my system and looking around for answers. Is there any way I can use this Database Tool (or anything else, for that matter), to bring my data back in to my new installation of BCM, when I haven't specifically been exporting to a backup file? I think the database itself has got to be in my backed up files. Thanks!

  83. Charley says:

    new computor with win 7 and outlook 2010 – have tried downloading bcm 4 times each saying succesful.  Does not show up on the outlook 2010 program or anywhere else that I can find.  This is a stand alone issue.  Conclusion – not worth the effort – time to look for a diferent CRM program that syncs with outlook  

  84. Kerry says:

    We are getting the below error message when trying to send a new  mass email under marketing Activities

    Error Message:

    Business Contact Manager for Outlook could not complete your last Action or actions. Please Try Again.

    Thanks,