BCM 2007 Remote Database Configuration (deploying tomorrow, need h

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jalalabadass - 28 Jan 2007 21:10 GMT

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.)

Reply to this Message

Luther - 29 Jan 2007 16:37 GMT

Read this first.

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

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

On Jan 28, 1:10 pm, jalalabadass
<jalalabad...@discussions.microsoft.com> wrote:

> Hello,
>
[quoted text clipped - 11 lines]
> 2007 to the desktops using command line switches to set various options I
> would appreciate it.)

Reply to this Message

jalalabadass - 30 Jan 2007 16:15 GMT

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?

> Read this first.
>
[quoted text clipped - 20 lines]
> > 2007 to the desktops using command line switches to set various options I
> > would appreciate it.)

Reply to this Message

Luther - 31 Jan 2007 16:08 GMT

On Jan 30, 8:15 am, jalalabadass
<jalalabad...@discussions.microsoft.com> wrote:

> 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
[quoted text clipped - 28 lines]
>
> - 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.

Reply to this Message

jalalabadass - 31 Jan 2007 23:58 GMT

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.

> On Jan 30, 8:15 am, jalalabadass
> <jalalabad...@discussions.microsoft.com> wrote:
[quoted text clipped - 39 lines]
> may have tightened those restrictions to meet Vista security
> requirements.

Reply to this Message

Luther - 01 Feb 2007 03:12 GMT

On Jan 31, 3:58 pm, jalalabadass
<jalalabad...@discussions.microsoft.com> wrote:

> 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
[quoted text clipped - 47 lines]
>
> - 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.

Reply to this Message