Error: "Server login has failed. (7029: failed to connect to the server (permission error))"
Description
Cause
Resolution

Verify Local Administrator Credentials

  1. Go to your Sage BusinessWorks Server click Start and type computer management.
  2. Expand the System Tools section on the left panel and then Local Users and Groups.
  3. Click the Users folder under Local Users and Groups. This will display all local user accounts on your system in the right panel.
  4. Select the user account you’re using on the administrator login prompt.
  5. Right-click and select Properties and then select the Member Of tab.
  6. If you don’t see the administrators group (NOT domain admin), click Add....
  7. In the Enter the object names to select field, type Administrators. Click Check Names and then click OK.
  8. Try the credentials again.
  9. If the user is in the Administrator group and the error persists, create a BWAdmin account. Then make it a local Administrator.
    • Use this account when prompted for the administrator login prompt

Verify Firewall Isn't Blocking Sage Tasks

If the error occurs during client installation in Workgroup edition, it indicates that there’s a blocked port on the Sage BusinessWorks server. 

  • Run a Telnet test to ensure ports 1583 and 3351 are open and listening
    • If using another firewall vendor, contact your vendor for assistance with opening ports 1583 and 3351

Verify the Database Engine Is Running on the Server

  1. Select Windows Start and type Services.
  2. Verify that Started appears in the Status column for the appropriate service.
    • Actian Workgroup or Pervasive PSQL Workgroup Engine (Workgroup)
    • Actian Enterprise Engine or Pervasive Transactional Engine and Relational Engine (Client Server)
  3. If the service isn’t running, right-click the service, and then click Start.
  4. If the engine is running on the server, restart the database engine.
[BCB:163:Chat BusinessWorks US:ECB]

 

Steps to duplicate
Related Solutions