Failed to transfer SBA database.

[Root]

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

 

[Luther]

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 theinfo
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 clickingon
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

I expect OA users may know more about the issues you are describing.
You can ask them in their newsgroup, microsoft.public.sba.general.

 

[Adam]

I found the solution in case anybody else ever gets this message. If you are
ever upgrading from SBA 06 and try to integrate the upgraded OA file with
BCM, you need to make sure multi-user is disabled or you will get that
message. After integrating with BCM you can then enable multi-user again.
Hope this helps anybody else.