Errors

Error: Cannot Connect to Database Login Failed for user DACUser in Accounts Production Advanced

Scenario

You might get the following error message after you install Accounts Production Advanced.
Error message
Cannot Connect to Database Login Failed for user DACUser.

Solution 1: If you have a new install of Accounts Production Advanced version 6.21

important
The steps in this topic should only be carried out by your firm's IT professional.
Server install
  1. Check that the software opens on the server without error.
  2. If the software doesn't open on the server ensure a backup of the database has been taken. Uninstall Accounts Production Advanced using programmes and features. Then browse to “C:\Program Files (x86)\Digita” and rename the Accounts Production Advanced folder to Accounts Production Advanced.OLDaza. Then run the
    DigitaAutoRun.exe
     from the download and reinstall DAPA.
  3. If DAPA opens and logs in on the server, the issue is that the node installs on the client machines are not updated.
  4. On the workstation browse to the node setups
    \\<SERVER NAME>\Digita\Accounts Production Advanced\Nodeins
     and run Setup.bat.
  5. If installing this has not fixed the issue, then go onto the server and copy the
    Installer.msi
     file from “Suite Download\Content\DAPA” into “C:\Program Files (x86)\Digita\Accounts Production Advanced\Nodeins\MSI”.
  6. On the workstation > Browse to Nodeins on server
    \\<SERVER NAME>\Digita\Accounts Production Advanced\Nodeins
     and the run
    Setup.bat
     file.
Standalone install
  1. Open DAPA, and if it says on the splash screen that it is running 6.20 try running the installation again.
  2. If the software says 6.21 browse into the program files which as a default are in the following location:
    C:\Program Files (x86)\Digita\Accounts Production Advanced
    .
  3. Run the
    databaseupgrader.exe
     application to upgrade the database, then try opening up the software again.
  4. If it continues to error, uninstall and reinstall the software.

Solution 2: if you installed any version other than 6.2

Option 1
  1. If you have just installed a node installation of Accounts Production Advanced by running
    Installer.msi
    , uninstall it and reinstall by running
    setup.bat
  2. If, when run, the black box vanishes quickly or does nothing, edit
    setup.bat
     in Notepad and ensure the network path entries are correct and valid. The default path references the installation files as if the "Digita" folder is shared and labelled "Digita", in accordance with the general installation instructions.
Option 2
If the database upgrade failed and database is now in Restricted mode:
  1. Open SQL Management Studio on the server, right click on
    Accounts Production Database
    , select
    Properties
    , then
    Choose Options
    .
  2. Scroll to the bottom of the list and change Restrict Access from
    RESTRICTED_USER
     to
    MULTI_USER
     and select
    OK
    .
note
Accounts Production Advanced will open and connect to database.
Option 3
If the user accounts and permissions have not been set up correctly:
  1. Using SQL Server Management Studio, select
    New Query
     and in the database dropdown box select
    AccountsProduction
     database.
  2. Enter
    Security
     and select
    Execute
    .
  3. Try Accounts Production Advanced again.
Option 4
If the DACUser account has an incorrect password:
  1. In SQL Server Management Studio, expand each database and check in:
    Databases >  DATABASE_NAME > Security > Users
    .
  2. Delete
    DACUser
     if it exists in each database user list.
  3. Expand
    Security
    , then
    Logins
    .
  4. Delete
    DACUser
    .
  5. Select
    New Query
    , then
    AccountsProduction
    .
  6. Enter
    Security
    , then select
    Execute
    .
  7. Try Accounts Production Advanced again.
Option 5
Ensure you've also updated Accounts Production if you installed it when you updated Accounts Production Advanced.
For example, Digita Accounts Production Advanced 6.21 Build 8540.1.195 requires Digita Accounts Production 5.10 Build 5454.

This article applies to:

  • Product: Digita Accounts Production Advanced
  • Subject: Setup