Can't share DB....

[JMIC]

Hi there,

If anyone can help, I would appreciate..
Excuse me for this long post : I'm giving all the configuration steps
and tests I've done to try to make this thing work ! In that way, we
will maybe not loose time testing basic things (if I didn't forget one
Some days ago, I managed to make it work on a dev environment and did
some successful tests with offline mode, I tried to reproduce on my prod
environment, I can't.

I tried to use the BCM DB admin tool to avoid installing outlook 2007 on
a server only for BCM 2007. The goal is to have one (actually, 2 or 3)
shared DB on my LAN, one for each business unit.
With the BCM DB admin tool, it didn't work. Now I'm trying with an OL
2007 to be sure, but it's still not working.

=> Each time I'm trying something new, I uninstall everything regarding
SQL server, BCM and so on - just in case, to be from scratch.

Here's what I've tested, there must be something missing, I don't know
what and I'm loosing my nerves with this tool

1) installed an OL 2007 on a W2K3 32 bits server. I ran everything on
this server with a domain administrator account, let say MYDOM\myadmin

2) installed the BCM from the Office CD #2 (english version)

3) created a DB called MYDB

4) I checked every checkbox talking about sharing the DB with other
people from other computer on my windows domain. I added my real-life
account to test : MYDOM\myname. So the installation process told me two
users would be able to access the DB : MYDOM\myadmin & MYDOM\myname. OK.

5) I deactivated the XP firewall before on the server, just to be
sure... I don't have anything else at network level preventing my client
PC to connect to this "BCM server" - see point 8 for further details.

6) I created one contact (in case it's working one day

7) on the client PC (logged on as MYDOM\myname, running XP SP2 + OL 2007
& BCM - french version, so it differs from the server, but I don't have
choice because some users are using EN outlook, some FR outlook), I
tried to connect to the_remote_server (I tried with the IP and so on)
I think when it worked on my dev system, it was with french Outlooks on
both sides. But I tried it again and couldn't manage to make it work
anymore...

====> It can't access it.

8) I verified the network things : I can ping, I can access network
shares on the remote server, I can telnet the_remote_server on ports
like 139 445 & 5356 which seem to be the only ones used by BCM 2K7.
I used netstat -an to be sure the server was listening on all net
interfaces available (which is the case : 0.0.0.0:5356/TCP and so on)
I also dumped the network traffic between these 2 hosts, I can see TCP
(maybe UDP I don't remember) on 139, 445 and 5356.
I checked the DB settings : TCP/IP port is 5356, for all network interfaces.
I can do a osql -E -S the_remote_server\MSSMLBIZ,5356 I get a comman
line prompt (I got this idea from a MS documentation - which is
outdated because talking about the 2003 version I guess (DB instance =
microsoftsmlbiz, port 56183)
=> so the network seems really OK.


===> What else can I do ?
I saw some messages on this newsgroup talking about OrgTable (and
others) that might contain incorrect flag (like a "this DB is
shared"-flag). I'd like to check this, but I can't connect to the local
DB via the SQL Srv Mnmgt Studio express. I'm using "windows
authentification" locally on "the_remote_server" with MYDOM\myadmin, I
can't log in
I tried many stupid things with sa DB account, I can't access neither....

How am I supposed to access this DB (which really exists, I can see that
from the BCM DB admin tool or when I uninstall because it asks me I must
remove my instance and DB)

Many thanks if someone can help

Jacques M

 

[Dmitri Yukhnovets]

I read on one of the blogs that may not be able connect to ENG db (created by
ENG Outlook version) from GER Otlook ie if Outlooks from different country
distributives. But you can connect to db even you change you regianl settings
from ENG to GER.....

Check on the server what ports the instance is using and setup proper if you
didn't do this. Normaly ports are 1433 for SQL server or 5356 for BCM'07

Whay you cant run MS SQL Mgmt Tool on the server to check OrgTable, or using
RDP.... if you can't conect from another station?

 

[JMIC]

JMIC a écrit :

Hi there,

If anyone can help, I would appreciate..
Excuse me for this long post : I'm giving all the configuration steps
and tests I've done to try to make this thing work ! In that way, we
will maybe not loose time testing basic things (if I didn't forget one
Some days ago, I managed to make it work on a dev environment and did
some successful tests with offline mode, I tried to reproduce on my prod
environment, I can't.

I tried to use the BCM DB admin tool to avoid installing outlook 2007 on
a server only for BCM 2007. The goal is to have one (actually, 2 or 3)
shared DB on my LAN, one for each business unit.
With the BCM DB admin tool, it didn't work. Now I'm trying with an OL
2007 to be sure, but it's still not working.

=> Each time I'm trying something new, I uninstall everything regarding
SQL server, BCM and so on - just in case, to be from scratch.

Here's what I've tested, there must be something missing, I don't know
what and I'm loosing my nerves with this tool

1) installed an OL 2007 on a W2K3 32 bits server. I ran everything on
this server with a domain administrator account, let say MYDOM\myadmin

2) installed the BCM from the Office CD #2 (english version)

3) created a DB called MYDB

4) I checked every checkbox talking about sharing the DB with other
people from other computer on my windows domain. I added my real-life
account to test : MYDOM\myname. So the installation process told me two
users would be able to access the DB : MYDOM\myadmin & MYDOM\myname. OK.

5) I deactivated the XP firewall before on the server, just to be
sure... I don't have anything else at network level preventing my client
PC to connect to this "BCM server" - see point 8 for further details.

6) I created one contact (in case it's working one day

7) on the client PC (logged on as MYDOM\myname, running XP SP2 + OL 2007
& BCM - french version, so it differs from the server, but I don't have
choice because some users are using EN outlook, some FR outlook), I
tried to connect to the_remote_server (I tried with the IP and so on)
I think when it worked on my dev system, it was with french Outlooks on
both sides. But I tried it again and couldn't manage to make it work
anymore...

====> It can't access it.

8) I verified the network things : I can ping, I can access network
shares on the remote server, I can telnet the_remote_server on ports
like 139 445 & 5356 which seem to be the only ones used by BCM 2K7.
I used netstat -an to be sure the server was listening on all net
interfaces available (which is the case : 0.0.0.0:5356/TCP and so on)
I also dumped the network traffic between these 2 hosts, I can see TCP
(maybe UDP I don't remember) on 139, 445 and 5356.
I checked the DB settings : TCP/IP port is 5356, for all network
interfaces.
I can do a osql -E -S the_remote_server\MSSMLBIZ,5356 I get a comman
line prompt (I got this idea from a MS documentation - which is
outdated because talking about the 2003 version I guess (DB instance =
microsoftsmlbiz, port 56183)
=> so the network seems really OK.


===> What else can I do ?
I saw some messages on this newsgroup talking about OrgTable (and
others) that might contain incorrect flag (like a "this DB is
shared"-flag). I'd like to check this, but I can't connect to the local
DB via the SQL Srv Mnmgt Studio express. I'm using "windows
authentification" locally on "the_remote_server" with MYDOM\myadmin, I
can't log in
I tried many stupid things with sa DB account, I can't access neither....

How am I supposed to access this DB (which really exists, I can see that
from the BCM DB admin tool or when I uninstall because it asks me I must
remove my instance and DB)

Many thanks if someone can help

Jacques M

Finally, I could connect from the sql server manamgent, using
"the_remote_server\MSSMLBIZ" instead of "the_remote_server" or localhost

I checked the OrgTable, I see a colum talking about the language.... I
really hope I can use different outlook languages....

What can I check at DB level to make my remote access work ?

If someone knows... Thank you

 

[JMIC]

Dmitri Yukhnovets a écrit :

I read on one of the blogs that may not be able connect to ENG db (created by
ENG Outlook version) from GER Otlook ie if Outlooks from different country
distributives. But you can connect to db even you change you regianl settings
from ENG to GER.....

I think something like this is happening. I'm switching my client PC
office from FR to EN to test. I'll use the same CD to be sure...
I can't believe this would be the solution.... I'm testing and keeping
you informed.

Check on the server what ports the instance is using and setup proper if you
didn't do this. Normaly ports are 1433 for SQL server or 5356 for BCM'07

Whay you cant run MS SQL Mgmt Tool on the server to check OrgTable, or using
RDP.... if you can't conect from another station?

fixed now, I had to enter "the_remote_server\MSSMLBIZ" as the server name
Thanks, anyway

 

[Dmitri Yukhnovets]

dbType to 1 to share, 0 to non share

JMIC a écrit :

Finally, I could connect from the sql server manamgent, using
"the_remote_server\MSSMLBIZ" instead of "the_remote_server" or localhost

I checked the OrgTable, I see a colum talking about the language.... I
really hope I can use different outlook languages....

What can I check at DB level to make my remote access work ?

If someone knows... Thank you

 

[JMIC]

Dmitri Yukhnovets a écrit :

dbType to 1 to share, 0 to non share

thanks

Ok, I can access my DB with the same OL 2007 "language-version"
I can't believe MS people can't do a multi-language tool !!!!!!!!
How are we supposed to do to manage people from different countries
using this tool ?! They can't all understand english (especially in word
and the other office's applications)

1) Does someone know if modifying the language key in OrgTable would be
a work-around ? or is the DB totally language-specific ?

2) I'll try to install an english BCM on a french outlook (office)....
I already did the opposite one day, I think.

I'll tell you...

 

[JMIC]

2) I'll try to install an english BCM on a french outlook (office)....

I already did the opposite one day, I think.

I'll tell you...

You can do that, eveyrthing seems to be working fine.

Finally : just install the same BCM (same CD) everywhere, in one single
language...
At least the common Office tools (word...) will be in an appropriate
language for the user.

'hope the problem I described and solved can help someone else.

see you

 

[Dmitri Yukhnovets]

http://blogs.msdn.com/bcm/archive/2...a-business-contact-manager-2007-database.aspx

Q: I can connect to the shared database from client computer through SQL
command or Management Studio fine; however, I could not connect through BCM
client.

A: The Business Contact Manager Database must be of same version and locale
as the BCM installed on client computer. We do not support sharing between
different versions of BCM, e.g. sharing won’t work if having BCM 2003 on the
server and BCM 2007 on the client. Neither do we support sharing between
different BCM locales. User cannot share a German BCM DB and connect to it
from an English BCM client. Please note that BCM locale here is independent
from OS user locale settings. If the OS setting is German and BCM is English,
then the above sharing scenario will work.

 

[Luther]

http://blogs.msdn.com/bcm/archive/2007/04/25/how-to-share-a-business-...

Q: I can connect to the shared database from client computer through SQL
command or Management Studio fine; however, I could not connect through BCM
client.

A: The Business Contact Manager Database must be of same version and locale
as the BCM installed on client computer. We do not support sharing between
different versions of BCM, e.g. sharing won’t work if having BCM 2003 onthe
server and BCM 2007 on the client.  Neither do we support sharing between
different BCM locales. User cannot share a German BCM DB and connect to it
from an English BCM client. Please note that BCM locale here is independent
from OS user locale settings. If the OS setting is German and BCM is English,
then the above sharing scenario will work.

It would be very difficult to have multilanguage clients on a single
database. For one thing, sorting is done on the server--the collation
setting on the database--and different languages sort differently.
Dates and numbers also have different formats. It's feasible to have
one format on the server, and have clients handle the translations,
but even multinational companies tend to pick one language, currency,
etc., for their central databases.

I remember in version 1 betas, BCM saying that considered how they
could support different locales, and decided to only support single
locale installations; i.e., only the same locale for Windows, Office,
Sql, and BCM. The cost of testing all the permutations was too high,
compared to the number of small businesses interested in having PCs
running different locales. Some combinations are possible, but they
are not supported. Note that even in the simple example above (German
OS and English BCM), the BCM user would see prices with the Euro
symbol, used in Germany, while a user on a UK OS would see Pound signs
for the same prices.