Unable to connect to remote database

[ThePro]

Hi,

I just installed the "Business Contact Manager for Outlook 2007 Database
Tool" on a server and we can't connect to this database with Outlook 2007
with BCM.

Some details:

Server: Windows Server 2003 SP2 (member server), MS SQL Server Express 2005,
SQL instance MSSMLBIZ, TCP/IP enabled, no firewall, on the same LAN than
client computers.

Client: Windows XP SP3, Outlook 2007 (connected to an Exchange Server 2003
in cache mode), BCM 2007 SP1.

When I finish to share the database on the server, I get this informations:
------
For a user who has already installed Business Contact Manager for Outlook

1.. On the Business Contact Manager menu, point to Database Tools, and
then click Create or Select a Database.
2.. In the Create or select a Business Contact Manager database dialog
box, click Select an existing database.
3.. In the Computer name box, enter BCM\MSSMLBIZ which is the name of the
computer where the shared database is located, and then click Connect.
4.. In the Database name list, if more than one database is listed, click
the name of the shared database (AUTOMATISATION), and then click Next.
5.. Click Finish.
------

I follow these instructions but I have the "unable to find BCM databases on
computer BCM\MSSMLBIZ " error message in Outlook.

Any ideas ?

Thanks.

ThePro

 

[Azur]

Hello,

Have you tried typing the netbios name of your SQL server instead of
BCM\MSSMLBIZ ?


The DataBaseTool is working in english version only.

is it the same version for the client ?

is your database populated ?


sorry for my bad english


-azur-

 

[ThePro]

Hi,

See inline answers.

Thanks.

ThePro

Hello,

Have you tried typing the netbios name of your SQL server instead of
BCM\MSSMLBIZ ?

Same error.

The DataBaseTool is working in english version only.

is it the same version for the client ?

No, client is french. There is no database tools for the french version ?

is your database populated ?

How can I verify this ?

 

[Azur]

Have you tried typing the netbios name of your SQL server instead of

Same error.

No, client is french. There is no database tools for the french version ?

I've tried this unfortunly

[j'ai déja essayé cela ne fonctionne pas]

How can I verify this ?

do you have entering data before ?

[As-tu déja commencé la saisie de données?]

if the database is Blank try this :

http://groups.google.fr/group/micro...osoft.public.crm+author:azur#9657de79e86a9220


[il faut créer la base de donnée sur le poste client-francais et recopier
celle-ci dans sql server du serveur]

-azur-

 

[ThePro]

Man, you saved my day.

[Monsieur, vous m'avez sauvé la vie]

Merci beaucoup.

ThePro

Same error.

No, client is french. There is no database tools for the french version ?

I've tried this unfortunly

[j'ai déja essayé cela ne fonctionne pas]

How can I verify this ?

do you have entering data before ?

[As-tu déja commencé la saisie de données?]

if the database is Blank try this :

http://groups.google.fr/group/micro...osoft.public.crm+author:azur#9657de79e86a9220


[il faut créer la base de donnée sur le poste client-francais et recopier
celle-ci dans sql server du serveur]

-azur-

 

[ThePro]

Hi again,

Now I can access the shared database with my login but not the other users.
I can't use the Database Tool to share the database because the tool does
not "see" it. Is there a way to give users access rights with SQL Studio ?

Thanks.

ThePro

Same error.

No, client is french. There is no database tools for the french version ?

I've tried this unfortunly

[j'ai déja essayé cela ne fonctionne pas]

How can I verify this ?

do you have entering data before ?

[As-tu déja commencé la saisie de données?]

if the database is Blank try this :

http://groups.google.fr/group/micro...osoft.public.crm+author:azur#9657de79e86a9220


[il faut créer la base de donnée sur le poste client-francais et recopier
celle-ci dans sql server du serveur]

-azur-

 

[Azur]

Hello,

Using SQL studio --> right clic on the name of your shared database
(SmallBusinessMS in my case)--> then propertly-->>then autorisations

then Add etc...

-azur-

Hi again,

Now I can access the shared database with my login but not the other
users. I can't use the Database Tool to share the database because the
tool does not "see" it. Is there a way to give users access rights with
SQL Studio ?

Thanks.

ThePro

Have you tried typing the netbios name of your SQL server instead of
BCM\MSSMLBIZ ?

Same error.

The DataBaseTool is working in english version only.

is it the same version for the client ?

No, client is french. There is no database tools for the french version
?

I've tried this unfortunly

[j'ai déja essayé cela ne fonctionne pas]

is your database populated ?

How can I verify this ?

do you have entering data before ?

[As-tu déja commencé la saisie de données?]

if the database is Blank try this :

http://groups.google.fr/group/micro...osoft.public.crm+author:azur#9657de79e86a9220


[il faut créer la base de donnée sur le poste client-francais et recopier
celle-ci dans sql server du serveur]

-azur-

 

[ThePro]

I finally gave up and I installed XP+ Outlook+BCM in a Hyper-V VM and it
works now.

Thanks.

ThePro