BCM 2007 Remote Database Configuration (deploying tomorrow, need h jalalabadass 1/28/2007 9:10:00 PM 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.)

Re: BCM 2007 Remote Database Configuration (deploying tomorrow, need h "Luther" <enowning[ at ]gmail.com> 1/29/2007 4:37:47 PM 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...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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.)

Re: BCM 2007 Remote Database Configuration (deploying tomorrow, ne jalalabadass 1/30/2007 4:15:00 PM 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" wrote: [Quoted Text] > 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...[ at ]discussions.microsoft.com> wrote: > > 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.) > >

Re: BCM 2007 Remote Database Configuration (deploying tomorrow, ne "Luther" <enowning[ at ]gmail.com> 1/31/2007 4:08:18 PM On Jan 30, 8:15 am, jalalabadass <jalalabad...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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" wrote: > > 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...[ at ]discussions.microsoft.com> wrote: > > > 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.)- Hide quoted text - > > - 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.

Re: BCM 2007 Remote Database Configuration (deploying tomorrow, ne jalalabadass 1/31/2007 11:58:01 PM 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" wrote: [Quoted Text] > On Jan 30, 8:15 am, jalalabadass > <jalalabad...[ at ]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 > > 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" wrote: > > > 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...[ at ]discussions.microsoft.com> wrote: > > > > 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.)- Hide quoted text - > > > > - 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. > >

Re: BCM 2007 Remote Database Configuration (deploying tomorrow, ne "Luther" <enowning[ at ]gmail.com> 2/1/2007 3:12:05 AM On Jan 31, 3:58 pm, jalalabadass <jalalabad...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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" wrote: > > On Jan 30, 8:15 am, jalalabadass > > <jalalabad...[ at ]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 > > > 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" wrote: > > > > 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...[ at ]discussions.microsoft.com> wrote: > > > > > 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.)- Hide quoted text - > > > > - 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.- Hide quoted text - > > - 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.