Installing BCM on a standard SQL server

CRM Forum » Outlook with BCM

Installing BCM on a standard SQL server

(7 posts)

Started 1 year ago by UG Bot
Latest reply from UG Bot

Tags:

UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: eric.bouchardlefebvre

Hello,

I am new to BCM, so my question may be a little be basic.

I am IT Manager for a mid-size company. Couple of weeks ago, we moved a desktop machine from a room to another and discovered, out of a sudden, that people in the sales department were not able to access their BCM anymore. We then understood that someone had install the software on this inappropriate machine.

So last week, we decided to move BCM on one of our servers. I first thought that BCM was a standard client-server software, the SQL database acting as the server part. When I took a deeper look at the desktop where the central database is located, I found that only a small package of SQL Server was installed.

My questions are :

1. Is BCM a standard clients-server application (outlook = clients and SQL = server) or a peer-to-peer application made of many outlook instances ?
2. Can I install BCM database on a SQL Server instance and have this instance deliver data to outlook clients
3. If so, do I need to install BCM on the "server" machine or can I just mount the BCM database on the SQL Server?

Thank you for your help,
EBL

Posted 1 year ago #
UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Re: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: gamer2k4

On Aug 25, 8:44 am, eric.bouchardlefeb...@gmail.com wrote:
> 1. Is BCM a standard clients-server application (outlook = clients and
> SQL = server) or a peer-to-peer application made of many outlook
> instances ?

I'm almost positive that it's clients-server.

> 2. Can I install BCM database on a SQL Server instance and have this
> instance deliver data to outlook clients

Yep, and I think that's actually a pretty common method of using BCM.

> 3. If so, do I need to install BCM on the "server" machine or can I
> just mount the BCM database on the SQL Server?

This link might help:
http://www.microsoft.com/downloads/details.aspx?FamilyID=B8E7AA0F-F593-4FB4-B822-DD662AF1A6CB&displaylang=en

It's a program called BCM Database Admin Tool, and it allows you to create and manage a BCM database on a server without requiring you to install Outlook or BCM on that machine.

Posted 1 year ago #
UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Re: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: farouk drif

hello everybody i wrote this message in English and French because the support (like the database admin tool) is not the same for the French version, you will understand when you read.

i guess from your email that you are French, unfortunately the database admin tool does not support bcm in French, it only works for English version. so you will have to create the database manually with sql scripts like i did it a few month ago. but before microsoft release his database admin tool, they published a procedure to create a database on a sql server: "Deploying Outlook 2007 with Business Contact Manager in a Remote Database Configuration" follow the link:
http://blogs.msdn.com/bcm/archive/2007/03/28/database-deployment-whitepaper-revised.aspx

if you want some details, i will be happy to help you

Posted 1 year ago #
UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Re: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: Azur

Sorry for my bad english
Hello,
I'm trying deploying Business Contact Manager Database in a sbs2003 R2 context.
I have downloaded the utility "database admin tool" linked.
I'm a beginner with sql 2005.
So, can you confirm that this utility does not support bcm in French? Did you try it?
I 'm reading the Deploying Outlook 2007 with Business Contact Manager in a remote Database Configuration guide (pffff it's long)
It seems to be Hard for me.
My BCM is in French.
If I'll make all that is explain in the guide, in the French Db context, it will be ok?
What are the points where i must make attention ?
Thanks
-azur-

Bonjour,
J'essai de créer ma base de donnée de partage sur un serveur SBS 2003 R2 (SQL2005sp2)
J'ai téléchargé l'outil Database admin tool du lien.
Je suis un débutant SQL 2005.
Peux-tu me confirmer que cet outil ne fonctionne pas en français? l'as-tu essayé ?
A la lecture du document sus-cité, cela parait difficilement réalisable pour moi.
La version BCM que j'utilise est 2007 en français.
Si j'utilise point par point la méthode expliqué, cela fonctionnera t'il ?
Quel sont les points ou je devrais faire attention ?
Merci
ps: je viens de me farcir la tentative d'installation avec une instance MSSQLSERVER, modif de la mdr, vérification des droits,etc... je fume un peu des oreilles
-azur-

Posted 1 year ago #
UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Re: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: Luther

I've heard that the BCM database tool is English only. If that's the case, you should contact your local Microsoft representative and tell them that translating this into the local language is important to their customers.

Posted 1 year ago #
UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Re: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: Azur

I've heard that the BCM database tool is English only. If that's the case, you should contact your local Microsoft representative and tell them that translating this into the local language is important to their customers.

Unfortunately my employer, a small business, can't carry weight for making à French translation.

My Local Microsoft representative know who I'm and what is my Business. he don't care about making a translation . He just want to sell us, Microsoft Products.

But you 're right, i should call him just to make my voice heard one time and many over time with over customers.
I give me one month to install bcm database on my sql2005 server. After it'll be too late.
During this time i don't think that Microsoft can make a translation.
Perhaps my call could help over People soon but i must spent my time to work around this .
Thanks for your help.
Bonjour depuis la bretagne.
-azur-

Posted 1 year ago #
UG Bot

admin
Joined: Jul '08
Posts: 2,034

Newsgroup subject: Re: Can BCM database be installed on a standard SQL Server
Archived from: microsoft.public.outlook.bcm
Author: Azur

I am testing my Database now, my problem seem to be resolved.

First step on the server (sbs2003 in my case) SQL server 2005 sp2 instance name must be called: MSSMLBIZ
I've tried many many over solution's , i think Business Contact Manager is locked with that.

Second step (on the computer xp sp3 in my case)
Starting office2007, then crm and create a local database.
(be careful the sql server express service do not start automatically after a security update coming newly. you have to modify the property of the service connection to local system to work around)

Third step (on the computer)
Locate the SmallBusiness.mdf and SmallBusiness.ldf files local database (doc&settings etc....) copy them on a directory of the destination server. (ex c:\crmdatabase)

Fourth step (on the server)
Start sql server management studio launch the MSSMLBIZ server instance name.
double click on database then join browse the directory making up (crmdatabase) and attach it.

Return to the computer and say it you want to open a shared database (give the netbios serveur name) automatically the databasename appear. It's ok.
Now i am making many many test i''ll give you my conclusions
Sorry for my bad English . Is someone can make the correction for me ?
-azur-

Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.