If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
Thread Tools | |
Display Modes | |
|
|