Can BCM database be installed on a standard SQL Server

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

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


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


This link might help:
 http://www.**--****.com/ 

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.

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://www.**--****.com/ 

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  crer une base pour bcm sur un serveur sql indpendant 
ne supporte pas la version franaise et vous ne pourrez vous en servir, il 
vous faudra user de scripts sql afin de spcifier la langue franaise comme 
langue de tri par exemple parmi d'autres rglages. cependant microsoft a 
publi une procdure pour cela:"Deploying Outlook 2007 with Business Contact 
Manager in a Remote Database Configuration". je les ai suivi avec succs il y 
a quelques mois.
voici le lien:
 http://www.**--****.com/ 

si vous dsirez d'autres renseignements n'hsitez pas

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 crr ma base de donn de partage sur un serveur SBS 2003 R2 
(SQL2005sp2)

J'ai thargl'outil Database admin tool du lien.

Je suis un dutant SQL 2005.

Peux-tu me confirmer que cet outil ne fonctionne pas en franis ?
l'as-tu essay?

A la lecture du document sus-cit cela parait difficilement rlisable pour 
moi.

La version BCM que j'utilise est 2007 en franis.


Si j'utilise point par point la mhode 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, vification des droits,etc...
je fume un peu des oreilles


-azur-











"farouk dr<f" < XXXX@XXXXX.COM >com> a rit dans le message 


> hello everybody i wrote this message in english and french because t>e
> support (like the database admin tool) is not the same for the fren>h
> version, you will understand when you rea>.
>>
> i guess from your email that you are french, unfortunately the databa>e
> admin tool does not support bcm in french, it only works for englis> 
> versio>.
> so you will have to create the database manually with sql scripts like > 
> d>d
> it a few month ago. but before microsoft release his database admin  too>,
> they published a procedure to create a database on a sql server> 
> "Deployi>g
> Outlook 2007 with Business Contact Manager in a Remote Databa>e
> Configuration" follow the lin>:
>  http://www.**--****.com/ ;x
>>
> if you want some details, i will be happy to help y>u
>>
>>
>>
> bonjou>,
> je devine votre adresse mail que vous es francophone, l'outil>de
> microsoft qui sert crr une base pour bcm sur un serveur >ql 
> inden>ant
> ne supporte pas la version franise et vous ne pourrez vous en servir> il
> vous faudra user de scripts sql afin de spifier la langue fran>se 
> c>mme
> langue de tri par exemple parmi d'autres rlages. cependant microso>t a
> publiune procure pour cela:"Deploying Outlook 2007 with Busi>ess 
> Co>tact
> Manager in a Remote Database Configuration". je les ai suivi avec su>c 
>>il y
> a quelques >ois.
> voici le >ien:
>  http://www.**--****.com/ ;as>x
>
> si vous direz d'autres renseignements n'hitez pas 

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-

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-





 XXXX@XXXXX.COM ...