BCM 2003 shared database

[Brenna]

Yes, I know, I'm stuck to oldfashioned technology.

But nevertheless:

Here's a Windows XP + Office '03 + BCM working fine for me. Now I
planned to share my contacts with other collegues. I have an
"application server" running the same configuration (XP+03+BMC) which
is part of our backup system. So I decided to run the BCM database
there.

I copied a backup file from my system to this "other" computer and
restored the database. No problem.

Now I asked BCM for sharing this database to other users. BCM showed
up with the assistant explaining, what will happen next. As soon as I
hit OK, the dialogue hangs in the state "Firewall exceptions" (I',
writing from germany, I don't know what the exact writing in english
versions is). The computer is fine, but Oulook is completely dead.

So I decided to configure the exceptions myself. I added the needed
exceptions to the windows firewall, added the "printer and file"
stuff, configured the sql with the networt configuration, but I never
ever managed to contact the database from any other computer (in the
same subnet, btw).

Anyone any further hints for me?

Thank so much for your support and
greeting from rainy germany,
Oliver

 

[Luther]

Yes, I know, I'm stuck to oldfashioned technology.

But nevertheless:

Here's a Windows XP + Office '03 + BCM working fine for me. Now I
planned to share my contacts with other collegues. I have an
"application server" running the same configuration (XP+03+BMC)  which
is part of our backup system. So I decided to run the BCM database
there.

I copied a backup file from my system to this "other" computer and
restored the database. No problem.

Now I asked BCM for sharing this database to other users. BCM showed
up with the assistant explaining, what will happen next. As soon as I
hit OK, the dialogue hangs in the state "Firewall exceptions" (I',
writing from germany, I don't know what the exact writing in english
versions is). The computer is fine, but Oulook is completely dead.

So I decided to configure the exceptions myself. I added the needed
exceptions to the windows firewall, added the "printer and file"
stuff, configured the sql with the networt configuration, but I never
ever managed to contact the database from any other computer (in the
same subnet, btw).

Anyone any further hints for me?

Thank so much for your support and
greeting from rainy germany,
Oliver

My first guess is that sql on the server is not configured to use
BCM's tcp port, 56183, or has a difference instance name.

From the client try running:
sqlcmd -E -S yourserver\microsoftsmlbiz,56183 -d MSSmallBusiness

If sqlcmd is not found, try osql with the same command line.

Does it connect? If not, BCM won't find the database either.

Luther
http://beyng.blogspot.com/

 

[Oliver Brenscheidt]

My first guess is that sql on the server is not configured to use
BCM's tcp port, 56183, or has a difference instance name.
From the client try running:
sqlcmd -E -S yourserver\microsoftsmlbiz,56183 -d MSSmallBusiness
If sqlcmd is not found, try osql with the same command line.
Does it connect? If not, BCM won't find the database either.
Lutherhttp://beyng.blogspot.com/- Zitierten Text ausblenden -
- Zitierten Text anzeigen -

Thanks Luther for giving some hints. I was able to solve the problem.
I didn't knew, that SP3 came with SQL2005. So what I did now, I
installed SQL2005Express on the same machine and configured TCP with
the management tool. After this, the connection to the named instance
of BCM was no problem anymore.

Greetings from Germany,
Oliver