Summary
How to solve the error: "Could not connect to the Sage 50 Company Database. You must be an administrator (sysadmin) or a user with full accounting rights and third-party Read/Write Access." The error occurs when using the Sage Accounting migration tool.
Cause
- The password exceeds seven characters
- Third-party Read/Write Access isn’t enabled
- Migration tool doesn’t accept the password
- The password appears incorrect despite being valid
- The tool rejects passwords longer than seven characters
Resolution
Shorten the Password
- Ensure the password contains no more than seven characters.
- If the password is longer, delete any characters beyond the seventh.
- Try logging in again with the shortened password.
- Confirm that the migration tool proceeds without errors.
Enable Third-Party Read/Write Access
- Open Setup, then select Setup Users.
- Click sysadmin, then click Modify.
- Select the Read/Write Access option.
- Save the changes and verify that the migration tool now connects successfully.