> > We are currently using SBA 2006 with BCM 2003 on EXCH1 server. We were
> > originally looking to just transfer the databases to a new server SBA1, but
> > decided to upgrade to BCM 2007 and OA 2007 since if there was a time to do
> > it, now would be it. The new SBA1 server is on the same domain as EXCH1
> > which is active and critical in the daily operations of our business.
> >
> > Using the upgrade database features in both programs, we upgraded both of
> > the older databases on EXCH1 by doing a backup on EXCH1 and a restore backup
> > on SBA1.
> >
> > The issue that I can't find a solution to is when it comes time to integrate
> > the two files through the OA 2007 Integration Wizard, it says "Failed to
> > transfer SBA database." There are no other error codes or anything else I
> > can reference to try and find the issue.
> >
> > SQL SERVER 2005 is installed on SBA1 with the default instance being
> > MSSMLBIZ so that way everything can run through SQL SVR 05 instead of the
> > express.
> >
> > Here is what I have tried doing to no avail:
> >
> > 1. Connect the upgraded OA 2007 database to a newly created BCM 07 database
> > without any of the original BCM data and it still can't connect.
> >
> > 2. Connected to brand new OA & BCM databases (which worked perfectly) and
> > then imported all the BCM info into BCM but I could not see any of the info
> > in OA. I wanted to redirect OA to another database that I know had the info
> > I wanted but could not get it to work.
> >
> > 3. Regarding the above scenario: The only difference I noticed with the
> > Wizard connecting the new databases with the upgraded ones is when it came
> > to the user management screen, in the upgraded databases from EXCH1, a
> > message box appears saying that "this user has more then one role in SBA.
> > Please contact the administrator to assign a single role to this user. The
> > REVIEW ACCOUNTING 2007 PERMISSIONS window is empty for both OA and BCM
> > columns (after I already allowed BCM database to be shared and granted the
> > permissions in BCM 2007 earlier). I then click next and after clicking on
> > the integrate button, it starts the integration process. I then get the
> > error message found in the title of this question.
> >
> > 4. In a new OA 07 company, when I click on manage users, it allows me add
> > the users to SBA and grant them permissions. In the upgraded database,
> > whenever I try to add a user, the program crashes and I can never get past
> > that part.
> >
> > I'm thinking there may be a permissions issue, but I can't see why that
> > would affect the database transfer.
> >
> > I have no where else to go. Somebody please help.
> >
> > Adam