creating BCM database on a server

[Guest]

I would like to create (and share) a BCM database on a server (Small Business
Server 2003) rather than on one of our users workstations. When I go into the
BCM screen to "Create a new database" it will not allow me to enter a drive
letter with the database name, so it appears the only option is to create the
database on the workstation and share it.

Am I missing something? ...or is there a way to move the BCM database to the
server after it is created, then connect to it. Thanks.

 

[Guest]

Mark,
Search this group for PDFs and KBs and you will see two posts I made with
all the info you will need. Also search for 'remote database', something like
that to find threads like this:
How to land shared DB on server running Exchange
Although Outlook and Exchange are incompatible on the same machine,
several people have successfully turned off Exchange, installed Outlook
and BCM, created and shared a database, removed Outlook, and then
turned Exchange back on. That appears to be the least messy way to get
the shared db onto a server.

http://www.microsoft.com/communitie....bcm&mid=aca3f345-a3b1-4fde-9e92-f944f1750071

Note: BCM on 2003 (not the Beta 2007) doesn't natively allow for remotely
installing a DB, but it can be done. BCM 2007 does allow for this.

 

[Chris Swinney]

Susan,

Could you repost these PDF's regarding this. I am trying to get a BCM
database (ver 2 - Outlook 2003) on a SBS 2003 server running SQL 2005
Workgroup.

Have tried searching the group but the article no longer seem to appear.

Many thanks.

Chris

 

[heydude]

Susan,

Could you repost these PDF's regarding this. I am trying to get a BCM
database (ver 2 - Outlook 2003) on a SBS 2003 server running SQL 2005
Workgroup.

Chris,

Your'll find the doc you need at
http://www.microsoft.com/downloads/...ee-9ad5-4be5-b888-c9a50ae395ca&displaylang=en

When you go through the instructions, be careful. You can't just copy
and paste the 'sqlcmd ' lines as some of them are missing end quotes
and other stuff. I have created a half dozen batch files that do the
work. If you need them let me know and I'll post them for you.

One other caveat - I'm using SBS 2003 R2 (just upgraded for this very
purpose). You will need to install 2005 as a new instance before you
can do this. You can't use an existing 2005 instance.

I've followed the instructions and BCM on Outlook 2007 will connect to
it (when it's empty). I had a BCM backup when I used Outlook 2007 BCM
locally and when I restore this back to the server database, BCM can no
longer find any BCM databases on the server (that's a lot of BCM's!).

The Outlook 2007 BCM database that I had was the latest version (I
checked using the instructions in the doc) so no migration was needed.
Still doesn't work and I'm not sure why.

Anybody?

 

[heydude]

Chris,

Your'll find the doc you need at
http://www.microsoft.com/downloads/...ee-9ad5-4be5-b888-c9a50ae395ca&displaylang=en

When you go through the instructions, be careful. You can't just copy
and paste the 'sqlcmd ' lines as some of them are missing end quotes
and other stuff. I have created a half dozen batch files that do the
work. If you need them let me know and I'll post them for you.

One other caveat - I'm using SBS 2003 R2 (just upgraded for this very
purpose). You will need to install 2005 as a new instance before you
can do this. You can't use an existing 2005 instance.

I've followed the instructions and BCM on Outlook 2007 will connect to
it (when it's empty). I had a BCM backup when I used Outlook 2007 BCM
locally and when I restore this back to the server database, BCM can no
longer find any BCM databases on the server (that's a lot of BCM's!).

The Outlook 2007 BCM database that I had was the latest version (I
checked using the instructions in the doc) so no migration was needed.
Still doesn't work and I'm not sure why.

Anybody?

It looks like I have managed to solve this problem.

I created a local BCM database on one machine. I then restored my
original backup to this new database. I then exported it to a BCM file.
I connected to the empty database I created earlier on the server. I
then imported the BCM file into the server database and it *looks* like
everything is now there.

Hope this helps somebody else!

 

[Chris Swinney]

Heydude,

I had seen that article. Did you manage to get this to work then with the
Outlook 2003 BCM database (which is what I was after)? I had wondered if
that article could be used to mount the BCM ver 2 DB on a remote server.

Chris

 

[heydude]

Hi Chris,

I didn't manage to get to this to work with Outlook 2003 BCM but using
Outlook 2007 BCM (which I upgraded to about a month ago) it did work.

I was getting too much resistance and too many differing opinions to
attempt to go much further than I did with 2003.