Can BCM database be installed on a standard SQL Server

[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 departement were not able to access
their BCM anymore. We then understood that someone had instal the
software on this inapporpriate machine.

So last week, we decided to move BCM on one of our servers. I first
tought 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

 

[gamer2k4]

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/...0F-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.

 

[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



bonjour,
je devine à votre adresse mail que vous êtes francophone, l'outil de
microsoft qui sert à créer une base pour bcm sur un serveur sql indépendant
ne supporte pas la version française et vous ne pourrez vous en servir, il
vous faudra user de scripts sql afin de spécifier la langue française comme
langue de tri par exemple parmi d'autres réglages. cependant microsoft a
publié une procédure pour cela:"Deploying Outlook 2007 with Business Contact
Manager in a Remote Database Configuration". je les ai suivi avec succès il y
a quelques mois.
voici le lien:
http://blogs.msdn.com/bcm/archive/2007/03/28/database-deployment-whitepaper-revised.aspx

si vous désirez d'autres renseignements n'hésitez pas

 

[Azur]

Sorry for my bad english

Hello,

I'm trying deploing 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 Deploing Oullok 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-

 

[Luther]

Sorry for my bad english

Hello,

I'm trying deploing 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 Deploing Oullok 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 2003R2
(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-

"farouk drif" <[email protected]> a écrit dans le message
de7B76797F-1C6F-4DE4-8941-D3523D45D__BEGIN_MASK_n#[email protected]...








- Show quoted text -

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.

 

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


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

My Local Microsoft representative know who i'am and what is my Businness.
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 custommers.

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

Thanks for your help.

Bonjour depuis la bretagne.


-azur-

 

[Azur]

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


First step on the server (sbs2003 in my case)
SQL serveur 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 carefull the sql server express service do not start automatically after
a security update comming newly. you have to
modify the property of the service connection to local system to work
arround)


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 clic 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)
automaticaly 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-