bcm 2007 database of an MS SQL-Server 2000



  • 1. How do i print lables from outlook.
    I need to use my contacts to print lables. I cannot seem to get it right.
  • 2. How do I synchronize Business Contact Manager with laptops?
    I have a desktop that I want to be my base with my laptop synchronized to it. I know that I can link to the database on the desktop but I want it to leave a copy on my laptop without having to export and import. I currently us a Mirra database backup system that allows for synchronization. However, Outlook won't synchornize between computers. I don't have any problems with other programs including Microsoft Accounting program. If anyone has any help, please let me know.
  • 3. Can I use Outlook Rules to Create BCM History Items?
    I have incoming order confirmation emails that I want to autolink with a business contact if his/her email is specified in the order confirmation email; i.e. I want to be able to see what my business contacts have ordered by viewing their contact history. As I understand it, I cannot do this via standard BCM autolinking because the email address of the person who ordered is in the message body, not the "from" field. I'm assuming that I should use Outlook rules to do this, but I cannot figure out how. There are apparently no BCM rule actions. Can I do this autolinking using Outlook rules? If not, how else can I do it? Thank you!
  • 4. rename C:\Program Files\Microsoft SQL Server
    I think I may need to rename this, but it tells me access is denied. it seems to be here the problem is
  • 5. error message- setup failed to configure the server
    setupup failed to configure server- refer to setup error logs

bcm 2007 database of an MS SQL-Server 2000

Postby Ernst-Peter Schegge » Sat, 16 Jun 2007 16:32:23 GMT

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


Re: bcm 2007 database of an MS SQL-Server 2000

Postby b.schmidt » Sat, 16 Jun 2007 16:46:10 GMT


as mentioned before, try this:

Otherwise, I once discovered this document, which might be interesting 
for you too:


Ernst-Peter Schegge, am 15.06.2007 09:32:

Similar Threads:

1.BCM 2007 auf MS SQL-Server 2000 verlagern

Hallo an Alle,

bin mir nicht sicher, ob ich hier richtig bin. Hoffe es aber.
Ich habe folgende Frage. Ich habe Outlook 2007 und mhte die Datenbank auf
einen MS SQL-Server 2000 verlegen.
Kann mir jemand sagen, wie das geht?

Vielen Dank an alle


2.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?

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

5.Moving BCM 2007 Database to a SQL 2005 Server

One of our users has been testing BCM and we now want others to start
using it, they have just been using a local database but now I want to
move it to SQL Server. I thought I could just backup the database and
restore it on the server using the BCM Database admin tool. I first
created a new database on the server with the admin tool then backed
up his local database and restored this onto the server.
This seemed to work however although user1 was still the dbo of the
database he could not access the database but users that I shared the
database to could access it just not the dbo. In Studio Manager when I
right clicked on the database and click properties under database it
had the owner listed as administrator. Administrator is the user I ran
the admin tool as. Is this owner different from the dbo? I even tried
using the command sp_changedbowner to make sure the dbo is set
correctly and it now shows in Studio Manager as user1 instead of
administrator but the user still cannot access the db.
If I try and connect using sqlcmd -E -S 'servername'\'instance','port
I get the following error:
C:\>sqlcmd -E -S 'servername'\'instance','port no'
Msg 18456, Level 14, State 1, Server 'servername, Line 1
Login failed for user 'domain\user1'.
I have read that instead of restoring the database I could just export
the data then the dbo would be administrator. However I think I will
then have a problem where user1 will no longer be able to create new
fields in BCM which they need to be able to do.
Any help much appreciated.

6. BCM 2007 on SQL 2000 server

7. Can BCM database be installed on a standard SQL Server

8. BCM Database on central SQL server?



Who is online

Users browsing this forum: No registered users and 95 guest