Moving BCM Database to new SQL 2005 Server Mark 11/2/2008 10:27:01 PM I have installed SBS Server 2003 Premium which has MS SQL 2005. Using the BCM toolkit for Outlook 2007 I created new database. The client Outlook 2007 can access the empty database fine. If I add a contact it appears fine. I then used the same utility to backup the database on the old server, move the backup to the new server and then again using the tool did a restore. The restore completed successfully. I can actually browse the database using the "SQL Server Manager" and can see the restored contacts. When I access the BCM from the client Outlook 2007 I do not see any of the contacts. I have again used the tool to share the database and find the user in the list. I can't seem to access the old contacts. Any suggestions? Mark

Re: Moving BCM Database to new SQL 2005 Server Luther <enowning[ at ]gmail.com> 11/3/2008 7:35:40 PM On Nov 2, 2:27 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > I have installed SBS Server 2003 Premium which has MS SQL 2005.  Using the > BCM toolkit for Outlook 2007 I created new database.  The client Outlook 2007 > can access the empty database fine.  If I add a contact it appears fine.. > > I then used the same utility to backup the database on the old server, move > the backup to the new server and then again using the tool did a restore.   > The restore completed successfully.  I can actually browse the database using > the "SQL Server Manager" and can see the restored contacts.  When I access > the BCM from the client Outlook 2007 I do not see any of the contacts.  I > have again used the tool to share the database and find the user in the list. >  I can't seem to access the old contacts.   > > Any suggestions? > > Mark Is the BCM database on the new server empty of all data, or just missing Contacts?

Re: Moving BCM Database to new SQL 2005 Server Mark 11/3/2008 8:36:11 PM I initially did a create database using the BCM toolkit and established connection with the client workstation. I did connect to the database and had added a contact and all looked good. I then using the BCM Toolkit backed up the database on the old server and again using the Toolkit, restored that datase backup. As I stated earlier, I am able to see contact records in the database. [Quoted Text] > On Nov 2, 2:27 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: > > I have installed SBS Server 2003 Premium which has MS SQL 2005. Using the > > BCM toolkit for Outlook 2007 I created new database. The client Outlook 2007 > > can access the empty database fine. If I add a contact it appears fine.. > > > > I then used the same utility to backup the database on the old server, move > > the backup to the new server and then again using the tool did a restore. > > The restore completed successfully. I can actually browse the database using > > the "SQL Server Manager" and can see the restored contacts. When I access > > the BCM from the client Outlook 2007 I do not see any of the contacts. I > > have again used the tool to share the database and find the user in the list. > > I can't seem to access the old contacts. > > > > Any suggestions? > > > > Mark > > Is the BCM database on the new server empty of all data, or just > missing Contacts? >

Re: Moving BCM Database to new SQL 2005 Server Mark 11/3/2008 9:08:07 PM To clarify, I can see the contacts in the database using SQL Management studio by browins the database directly. I cannot see the contacts from within BCN on the client workstation. "Mark" wrote: [Quoted Text] > I initially did a create database using the BCM toolkit and established > connection with the client workstation. I did connect to the database and > had added a contact and all looked good. I then using the BCM Toolkit backed > up the database on the old server and again using the Toolkit, restored that > datase backup. As I stated earlier, I am able to see contact records in the > database. > > > > On Nov 2, 2:27 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: > > > I have installed SBS Server 2003 Premium which has MS SQL 2005. Using the > > > BCM toolkit for Outlook 2007 I created new database. The client Outlook 2007 > > > can access the empty database fine. If I add a contact it appears fine.. > > > > > > I then used the same utility to backup the database on the old server, move > > > the backup to the new server and then again using the tool did a restore. > > > The restore completed successfully. I can actually browse the database using > > > the "SQL Server Manager" and can see the restored contacts. When I access > > > the BCM from the client Outlook 2007 I do not see any of the contacts. I > > > have again used the tool to share the database and find the user in the list. > > > I can't seem to access the old contacts. > > > > > > Any suggestions? > > > > > > Mark > > > > Is the BCM database on the new server empty of all data, or just > > missing Contacts? > >

Re: Moving BCM Database to new SQL 2005 Server Luther <enowning[ at ]gmail.com> 11/5/2008 5:54:00 AM On Nov 3, 1:08 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > To clarify, I can see the contacts in the database using SQL Management > studio by browins the database directly.  I cannot see the contacts from > within BCN on the client workstation. > > > > "Mark" wrote: > > I initially did a create database using the BCM toolkit and established > > connection with the client workstation.  I did connect to the database and > > had added a contact and all looked good.  I then using the BCM Toolkit backed > > up the database on the old server and again using the Toolkit, restored that > > datase backup.  As I stated earlier, I am able to see contact records in the > > database. > > > > On Nov 2, 2:27 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: > > > > I have installed SBS Server 2003 Premium which has MS SQL 2005.  Using the > > > > BCM toolkit for Outlook 2007 I created new database.  The client Outlook 2007 > > > > can access the empty database fine.  If I add a contact it appears fine.. > > > > > I then used the same utility to backup the database on the old server, move > > > > the backup to the new server and then again using the tool did a restore.   > > > > The restore completed successfully.  I can actually browse the database using > > > > the "SQL Server Manager" and can see the restored contacts.  When I access > > > > the BCM from the client Outlook 2007 I do not see any of the contacts.  I > > > > have again used the tool to share the database and find the user in the list. > > > >  I can't seem to access the old contacts.   > > > > > Any suggestions? > > > > > Mark > > > > Is the BCM database on the new server empty of all data, or just > > > missing Contacts?- Hide quoted text - > > - Show quoted text - If you add a contact with BCM, do you see it with Sql Mgtm Studio?

Re: Moving BCM Database to new SQL 2005 Server Mark 11/5/2008 2:28:01 PM The issue has been resolved. The problem turns out that you cannot just do a backup on the old server and restore the database to the new server. Even though I do have the same logins in active directory, the user security restored to the new database was not valid. If I tried to remove a users security for the database using MS SQL Management Studio, it reported that the user was not a valid user on the machine. To make a long story short, the way to accomplish this is to export the data to the BCM format, then import that information into the new blank database. Use the Outlook BCM Toolkit to then "Share" the database and setup the users. HTH Mark "Luther" wrote: [Quoted Text] > On Nov 3, 1:08 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: > > To clarify, I can see the contacts in the database using SQL Management > > studio by browins the database directly. I cannot see the contacts from > > within BCN on the client workstation. > > > > > > > > "Mark" wrote: > > > I initially did a create database using the BCM toolkit and established > > > connection with the client workstation. I did connect to the database and > > > had added a contact and all looked good. I then using the BCM Toolkit backed > > > up the database on the old server and again using the Toolkit, restored that > > > datase backup. As I stated earlier, I am able to see contact records in the > > > database. > > > > > > On Nov 2, 2:27 pm, Mark <M...[ at ]discussions.microsoft.com> wrote: > > > > > I have installed SBS Server 2003 Premium which has MS SQL 2005. Using the > > > > > BCM toolkit for Outlook 2007 I created new database. The client Outlook 2007 > > > > > can access the empty database fine. If I add a contact it appears fine.. > > > > > > > I then used the same utility to backup the database on the old server, move > > > > > the backup to the new server and then again using the tool did a restore. > > > > > The restore completed successfully. I can actually browse the database using > > > > > the "SQL Server Manager" and can see the restored contacts. When I access > > > > > the BCM from the client Outlook 2007 I do not see any of the contacts. I > > > > > have again used the tool to share the database and find the user in the list. > > > > > I can't seem to access the old contacts. > > > > > > > Any suggestions? > > > > > > > Mark > > > > > > Is the BCM database on the new server empty of all data, or just > > > > missing Contacts?- Hide quoted text - > > > > - Show quoted text - > > If you add a contact with BCM, do you see it with Sql Mgtm Studio? >