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.
Before you try the following solutions, you'll need to know which version of Accounts Production Advanced is the current version. Go to the Digita Suite Releases article to check. You can download the latest version from the Product Downloads page.

Solution 1: If you have a new install of the current Accounts Production Advanced

Server install
  1. Check that the application opens on the server without error.
  2. Check the application is the same version as in the current Digita Suite release.
  3. If the application doesn't open on the server, take the following steps.
    1. Make a backup of the database.
    2. Go to
      C:\Program Files (x86)\Digita
    3. Rename the Accounts Production Advanced folder to
      Accounts Production Advanced.OLD
    4. Run
      DigitaAutoRun.exe
       from the Digita Suite release download file and reinstall the application.
  4. If the application opens and logs in on the server, the problem is that the node installs on the client machines aren't updated.
    1. On the workstation go to the node setups at:
      \\<SERVER NAME>\Digita\Accounts Production Advanced\Nodeins
    2. Run
      setup.bat
      .
  5. If installing this hasn't fixed the problem, take the following steps.
    1. Go onto the server and copy the
      installer.msi
       file from
      Suite Download\Content\DAPA
      .
    2. Paste this file into
      C:\Program Files (x86)\Digita\Accounts Production Advanced\Nodeins\MSI
      .
    3. On the workstation, go to
      Nodeins
       on the server at
      \\<SERVER NAME>\Digita\Accounts Production Advanced\Nodeins
      .
    4. Run
      setup.bat
      .
Standalone install
  1. Open the application. If it says it's running a version older than the current version, run the installation again.
  2. If the application shows it's running the current version, go to the program files.
  3. Run the
    databaseupgrader.exe
     application to upgrade the database, then open the application again.
  4. If you get an error, uninstall and reinstall the application.

Solution 2: if you've installed any version other than the current one

Option 1
  1. If you've installed a node installation by running
    Installer.msi
    , run
    setup.bat
     to uninstall then reinstall it.
  2. If the box disappears or does nothing when you run
    setup.bat
    , take the following steps:
    1. Open
      setup.bat
       in
      Notepad
      .
    2. Make sure network path entries are correct and valid.
Option 2
If the database upgrade failed and the database is in
Restricted
 mode, take the following steps.
  1. Open SQL Management Studio on the server.
  2. Right-click
    Accounts Production Database
    , select
    Properties
    , then
    Choose Options
    .
  3. At the end of the list change
    Restrict Access
     from
    RESTRICTED_USER
     to
    MULTI_USER
    .
  4. Select
    OK
    .
Option 3
If the user accounts and permissions aren't set up correctly, take the following steps.
  1. In SQL Server Management Studio, select
    New Query
    .
  2. In the
    Database
     dropdown list, select the
    AccountsProduction
     database.
  3. Enter
    Security
    , then select
    Execute
    .
  4. Open the application again.
Option 4
If the
DACUser
 account has an incorrect password, take the following steps.
  1. In SQL Server Management Studio, expand each database and check
    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. Open Accounts Production Advanced again.
Option 5
Make sure you've also updated Accounts Production if you installed it when you updated Accounts Production Advanced.

This article applies to:

  • Product: Digita Accounts Production Advanced
  • Subject: Setup

Related content