Failed to transfer SBA database.

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

On Aug 4, 11:42 am, "Root" <r....DeleteThis@AIS.LOCAL> wrote:
> 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

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