BCM and SQL Server 2000



  • 1. How to open BCM file(not archived,just *.mdf &*.ldf)?
    My database was left after system reinslling but I didn't archived it
  • 2. Outlook 2007 w/BCM and Act! 2006
    Hello, I have both Act! 2006 and Office 2007 installed on my work laptop. Can I install and safely use Outlook 2007 w/BCM and Act! 2006 together at the same time? I know that in the past with Act! and Outlook 2003 w/BCM there were known conflicts when trying to use both applications together, so was wondering if it is still the same case. Thanks. Eric
  • 3. Managing contact lists in Biz Contact Manager
    Is there any way you can divide lists in the Accounts folder or Business Contacts folder so that you can quickly create a merge e-mail to be sent to those specific contacts? For example, we have Active and inactive accounts in our Accounts folder. Is there a way to filter the list so that we only send our message to the Active accounts? If so, how would this be done? -- Nona
  • 4. Why are business contacts added in accounts not shown in list Busi
    When you add a contact in the window of an Account this contact is not added in the Business Contacts list of my Addressbook, while it is in the Business Contacts folder of BCM (working with BCM 2007)
  • 5. SBCMSYNC.DLL error in Outlook 2002 running on VISTA
    After using the VISTA transfer files and settings program, Outlook now generates two error messages about the non-existant add-in SBCMSYNC.DLL. I have read lots of KB articles, but their non-registry solutions don't work and, of course, you can't get at the registry in VISTA. (I have already tried deleting the extend.dat file.) The computer I transferred from probably had Office 2000 before it was replaced by Office XP.

BCM and SQL Server 2000

Postby QVo » Fri, 16 Dec 2005 01:02:08 GMT

We already have sql serevr in our company, is it possible to install bcm on a 
client and connect the database to the sql server 2000 already in place.

I dont want to use the msde client stuff that it install and i would rather 
uninstall that.

Does anybody know if this is possible and if so how do i go about setting 
this up.

Re: BCM and SQL Server 2000

Postby Luther » Fri, 16 Dec 2005 01:39:00 GMT

It is indeed possible, but it won't work with the default installation.

You should create a new sql instance (named microsoftsmlbiz --
recommended). That instance _must_ use TCP port 56183, and you'll also
need to open that port in the server's firewall.

Re: BCM and SQL Server 2000

Postby QVo » Fri, 16 Dec 2005 03:19:01 GMT

Could u provide any more detail or any articles relating to this matter on 
how to setup bcm and connect it to sql server located on a serperate machine.


Re: BCM and SQL Server 2000

Postby Cello » Fri, 30 Dec 2005 01:27:25 GMT

Yes, please someone needs to share that information.

Re: BCM and SQL Server 2000

Postby Luther » Mon, 02 Jan 2006 08:48:36 GMT

Try searching earlier posts in this newsgroup. I'm not aware of any
articles. This isn't something Microsoft supports.

Re: BCM and SQL Server 2000

Postby TGFycnkgTC4 » Sat, 07 Jan 2006 03:11:02 GMT

I have the BCM database running on a SQL 2000 server with Terminal Services.  
In general, it works.  Below are considerations I have found.  Perhaps others 
have solutions to these:

1)  You need to run an "instance" on the server where the database is 
located.  This is because the BCM program is looking for the instance in 
order to access the database.  Consequently, you will need to run the SQL 
Server Service for that database on each workstation.  However, you will be 
able to access the full database via SQL, run queries, and do whatever you 
want.  It's a fairly straightforward db.

2)  The key issues are that it is still a young product with functional 
limitations.  Probably the biggest limitation is caused by the MSDE 
contraints, followed by some programmatic issues at the front-end.  

Microsoft probably did not anticipate that larger firms were interested in 
this product, so the development was centered towards single-person 
businesses or very very small businesses.  Not every firm though wants the 
complexity of CRM (nor the cost), and they do not want to spend the time in 
development of that product.  BCM is a start, but it needs a lot more.  Most 
firms want a product that is already developed/designed, but has flexibility 
so that it can be customized for each business.  My guess is that BCM is 
about 2 to 3 versions aways from becoming that product.


Similar Threads:

1.BCM database on SQL Server 2000

Hello. We are investigating using BCM for some of our sales people. We would 
like to have the BCM database setup on our existing SQL Server 2000. When I 
setup the BCM client (Outlook 2007 with BCM) it asks if I want to connect to 
an existing database, which can be on another computer, but there is no 
option to create the database on a remote server. Is this possible? If so, 
can someone point me to documentation on this?

2.bcm 2007 database of an MS SQL-Server 2000

I have a problem with Outlook 2007 and BCM. I will use my MS SQL-Server2000
for holding the database. Can show me evereybodey the way please.

Greetings to all


3.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

4.SQL Server 2000 & BCM

Does anyone know if it is possible that through a backup and restore of the 
MSBusinessContactManager within MSDE, that I could restore this database to a 
SQL Server 2000?

I have seen within the profile configuration for Mail Profiles, that the 
data file for BCM can be selected, has anyone attempted to migrate this 
database to SQL Server 2000, and change the reference to the BCM data file 

Also, does anyone know of a good resource to compare BCM and Microsoft CRM, 
and possibly other 3rd party vendor's like Goldmine?  Anyone have any 
comments regarding these CRM products would be greatly appreciated.


5.Sharing BCM database on SQL 2000 Server

I installed BCM 2003 on on XP computer, shared it and then copied it to our 
SQL 2000 server.  I enable dnamed pipes and TCP/IP to use port 56183.  
However,  when I try to connect my users to the database they can not locate 
any databases on our server.  Any thoughts would be greatly appreciated.

6. BCM 2007 on SQL 2000 server

7. Can BCM use SQL 2000/2005 server?

8. BCM 2007 auf MS SQL-Server 2000 verlagern



Who is online

Users browsing this forum: No registered users and 8 guest