Unable to connect to remote database

T

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
 
A

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-
 
T

ThePro

Hi,

See inline answers.

Thanks.

ThePro

Azur said:
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 ?
 
A

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-
 
T

ThePro

Man, you saved my day.

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

Merci beaucoup.

ThePro

Azur said:
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-
 
T

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

Azur said:
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-
 
A

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-


ThePro said:
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

Azur said:
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-
 
T

ThePro

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

Thanks.

ThePro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top