Running BCM database from a SBS 2003 server



  • 1. will not install
    I downloaded and installed Office 2007 which includes Outlook. I then downloaed and tried to install BCM-EN. It told me that the 2 didnt match. Ive deleytede and tried re-installing twice without success. Any suggestions as to what I can do? Please help! Thanks DL
  • 2. Cannot delete deleted items or emails from my Outlook 2007
    I am running Outlook 2007 as part of Office 2007 Professional Plus, and added BCM about 60 days ago. Within a few weeks, I would not be able to delete emails with attachments, such as photos, or to clean out my deleted items folder. When I try to empty my deleted items folder I get The messaging interface has returned an unkown error. If the problem persists, please restart Outlook." That doesn't work. Does anyone know what to do to correct this problem? -- Travel & Tourism ROCKS!
  • 3. Moving contacts and activities from BCM to OUtlook
    I am fed up with BCM, and i don't really need the additional features. I want to move all contacts, including tasks, and history items to OUtlook. How do i do this without re entering EVERYTHING? Thanks
  • 4. Can I link a single project to multiple accounts / business contac
    I am reviewing BCM 2007 to see if it will meet our needs. We are attempting to create a system that will allow us to track our accounts, contacts, projects (in the sales department) and opportunities. Everything seems to work well, except one major problem. It appears that I cannot link a project or opportunity to multiple accounts& business contacts. I can add "Related accounts & business contacts" to a business project, but this does not show up in the history of the accounts or business contacts that I've added. The history will only show up if it is linked, and best I can tell, you can only link one business project to one account / business contact. Am I missing something? Is there a workaround to this? If this is in fact the case, THIS MUST BE ADDRESSED IN FUTURE RELEASES. If I can't find a workaround, we will not be able to use BCM.
  • 5. Install SQL on a remote server for 2003?
    Hello, I have Outlook 2003 installed. I'd like to try using BCM in our location, but I don't want to install SQL on my machine. We would be sharing contacts. Is it possible to use a remote server/SQL db? I'd rather not have everyone hit my machine for the DB. Thanks!

Running BCM database from a SBS 2003 server

Postby Chris Swinney » Sat, 25 Nov 2006 04:01:48 GMT

Is it possible to create a BCM database on a client computer then move it to
a main server running SBS 2003 (with or with R2) and get client to connect
to that? I know there is a dull CRM package (MS CRM 3.0) but many of my
clients do not need this full functionality but it would be useful to store
the database in a more central location.

As far as I am aware, BCM uses the MSDE version of SQL. SBS 2003 R2 uses SQL
2005 workgroup edition but I'm sure it still has MSDE install for things
such as SBS Monitoring.

Many thanks for any information


Re: Running BCM database from a SBS 2003 server

Postby Raul » Sat, 25 Nov 2006 11:41:17 GMT

Hi Chris

You can try these steps and see if they help

Detach the MSDE 2000 or SQL Express 2005 data file, and then attach it again 
on a computer that is running SQL Server 2000 or SQL Server 2005.

For information about how to use the sp_attach_db procedure to attach a 
database to a server, visit the following Microsoft Web site:
For information about how to use the sp_detach_db procedure to detach a 
database to a server, visit the following Microsoft Web site:
For more information, visit the following Microsoft Web site:

I haven't tried this to be frank :)

With Regards

Raul Thomas

Re: Running BCM database from a SBS 2003 server

Postby Chris Swinney » Sun, 26 Nov 2006 02:50:46 GMT


Thanks for this. MS have said (of course) that this configuration is not 
supported, however, it would make so much more sense to store that DB on a 
central server machine like SBS 2003. MSDE and SQL 2005 are both used by SBS 
so it would make sense to utilise them and for any number of other reasons 
(availability, backup, remote access etc). CRM 3.0 is just to overkill for a 
lot of small companies both in terms of features and cost. Most of them want 
a simple two tier contacting system (Company --> Contact) and to be able to 
link incoming AND outgoing emails to those contacts - basically what BCM 

We had achieved something like though some reworking of Randy Bryne's
"Building Application with Outlook" that used Public Folders. This has work
successfully for us and other clients for some tim, but this has broken a 
bit with out new SBS install.


Re: Running BCM database from a SBS 2003 server

Postby Raul » Sun, 26 Nov 2006 03:51:00 GMT

No problem Chris - I could forward a white paper which might provide some 
info it you are interested :)

With Regards

Raul Thomas

Re: Running BCM database from a SBS 2003 server

Postby Chris Swinney » Sun, 26 Nov 2006 05:25:11 GMT

f you could - or just post a link if it avliable on the net.

"Raul" < XXXX@XXXXX.COM > wrote in message
news:ecPw%23l$ XXXX@XXXXX.COM ...

Similar Threads:

1.Running BCM database from a SBS 2003 server

2.BCM 2007 Shared Database on member Server 2008 in SBS 2008 Domain

3.Outlook BCM database should be able to be installed on SBS 2003

4.Run the BCM database on a SQL server 2000

Hello everybody, i have som questions about the migrations of BCMs databse 
from a MSDE to a SQL server.

1. is this possible and does it work, i have all the the questions and 
answer and it seems like it shold work, but does it work 100%. so if someone 
have done this migration, please just write som words and tell me about is.

2. I have contacted the Microsoft support and the limitations of the MSDE 
databse is 5 users and a BCM databse can be 2 GB big. If you migrate the BCM 
databse to a SQL server 2000, does the limitations disappears?

3. Can you use the BCM database in some sort of "offline" status, so you 
will be able to use the BCM database when you open Outlook 2003 outside of 
the office, example when you are home. When i do this now, is says it cant 
find the BCM database, beacause a work with a shared database that is on our 
Does anyone know if the "offline" databse i possible?

I appreciate all the help, tips and suggestions that you know of, i think 
this is som questions that more people than me would like to know.

Best regards

5.Outlook 2007 and Exchange running on a 2003 SBS Server

We are trying to use two email address for one user. The email address's are 
setup using Active Directory ( XXXX@XXXXX.COM  and 
 XXXX@XXXXX.COM ). In the Outlook Inbox I setup a folder (don). I would 
like 'donald' to go to inbox and don go to Inbox/don. In Active Directory 
'don and donald' are setup under user 'Donald Huffsmith'. My qustion is how 
do I solve this problem. I looked at Exchange, then Outlook rules! it works 
sometimes, Please help. 
Norm Bohana

6. BCM 2003 database running on SQL?

7. Outlook 2003 BCM--Update Lets BCM & SBS 2003 Work *Together*

8. Relocate BCM database to MSDE on SBS



Who is online

Users browsing this forum: No registered users and 4 guest