BCM 2007 Remote Database Configuration (deploying tomorrow, need h

[Guest]

Hello,

Situation: Currently my client has SBS 2003 with Exchange running on their
server. On the desktops they have Office 2003 Professional. Tomorrow I'm
going to be upgrading to Office 2007 Professional on all desktops including
BCM with the database residing on the server.

Question: I've read the bcm_sql document but it seems to apply to a beta
version of BCM. It says to create a SQL database manually etc. Is there a
more automated way to setup the database without installing Outlook w/BCM and
without working with SQL directly?

(Also if anyone can point me to a document with how best to assign Office
2007 to the desktops using command line switches to set various options I
would appreciate it.)

 

[Luther]

Read this first.

http://davidschrag.com/schlog/53/bcm-2007-typo-alert

The document David links to should have the database information you
need.

 

[Guest]

Ok, what I ended up doing was installing Outlook 2007 w/BCM on the server
just to create and setup the database and then uninstalled. This worked fine
and everyone can connect to the database but the domain Administrator account
is the only one that can create user-defined fields etc. I would like to
allow all users to do this. How can I change permissions to the database?

 

[Luther]

Ok, what I ended up doing was installing Outlook 2007 w/BCM on the server
just to create and setup the database and then uninstalled. This worked fine
and everyone can connect to the database but the domain Administrator account
is the only one that can create user-defined fields etc. I would like to
allow all users to do this. How can I change permissions to the database?





- Show quoted text -

The BCM model is that only the database creator/owner has certain
privileges, like managing user fields.

I know that in the past (bvm v2), anyone with nt admin privileges on
the machine with the database could do everything the database owner
could. However, I haven't experimented with that on bcm v3/2007. They
may have tightened those restrictions to meet Vista security
requirements.

 

[Guest]

That is what I ended up doing. I added the user to the domain admin group.
Fortunately, she is the "admin" at this small business so it worked out. Can
you change ownership of the database if necessary? If it were a user that
could not have admin access but needed to have full control of BCM this would
have been a problem.

 

[Luther]

That is what I ended up doing. I added the user to the domain admin group.
Fortunately, she is the "admin" at this small business so it worked out. Can
you change ownership of the database if necessary? If it were a user that
could not have admin access but needed to have full control of BCM this would
have been a problem.







- Show quoted text -

I suspect that you can do it by changing a value in the database
system tables using sqltools, but I don't think there's any mechanism
in BCM to transfer ownership of a database.