EXACTLY what happens when a domain user is granted access to shared BCM db

B

byersjus

My goal is to share business contacts company-wide and integrate those
contacts into our production database.

Everything worked great for me (the developer) but now I can't give
access to other users

Procedure:

1) Installed BCM on an XP machine under our domain admin username
2) Shared the database and added myselft as a user with access
3) Copied the BCM database from the MSDE instance to a SQL2000 instance
on a SBS machine
4) Installed BCM on my XP machine
5) Edited my XP machine's registry to point to the new SQL 2000
instance name on port 1433
6) Selected Shared database on my machine and connected to the SQL 2000
db fine
7) Uninstalled BCM and MSDE from the original machine
8) Uninstalled MSDE from my machine and everything is still fine
9) Used the BCM contact tables to drive our full size production
database
10) Installed BCM on another XP machine, edited it's registry
11) Attempted to connect to same SQL 2000 instance on new machine, but
error is returned saying make sure BCM is running that the DB is
shared, etc.

Now, I'm assuming that if I had granted all domain users access to the
shared db on the original XP machine when I did my own name everything
would be ok.

The problem is I can no longer use the "Share Database" menu selection
in my copy of Outlook because it is setup as a shared database client.

Which brings me to the question in the subject: When you select "share
database" inside Outlook and add users what is happening there? I need
to replicate it without the use of Outlook and I can't figure it out.

I've added the domain user in question as a login for SQL 2000 and a
user of the BCM database with the same roles as my (working) name.

No firewall is running on the server (even if it was I have access on
the same port from a different machine)

Any ideas?
 
L

Luther

Which brings me to the question in the subject: When
you select "share database" inside Outlook and add users
what is happening there?

In the user dept, the users are added to the database and made members
of the "bcm shared users" role.
 

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