This resource is targeted towards users who are looking for advanced options in deploying Acctivate. It's recommended that the standard installation process is followed for most environments and users.
It's strongly recommended that you review the information below and determine if the steps below apply to your use cases.
Silent MSI Install
The Acctivate installer is used to install the Acctivate.msi package and various third-party components required by Acctivate.
A non-interactive MSI install can be used to deploy Acctivate, however prerequisite components files must be installed. Below is a list of the required components that must be installed:
- .NET Framework 4.6.2 or later download
- Visual C++ 2015-2019 Redistributable 14.26.28720.03 or later download (32-bit)
- Visual C++ 2013 Redistributable 12.0.40664.00 or later download (32-bit)
- QBFC 13.0 download
- MS Access Database Engine 2010 download (32-bit)
- Crystal Reports for Visual Studio 13.0 SP29 download (32-bit)
- Microsoft OLE DB Driver for SQL Server 18.4 download (match OS bitness)
- Microsoft SQL Server 2012 or later. All editions except the Compact Edition are supported. download SQL Server 2019 Express edition
Some components, such as Microsoft SQL Server, have their own component requirements which may result in additional files being installed.
Once the above components are installed, a non-interactive MSI installation can be performed. To obtain the correct .msi package, download the current Acctivate version from the Downloads page and run the installer. The MSI will be extracted to one of the following locations:
- Temp folder for the Windows user
- The Update folder found in the AcctivateData share
Run the following command line in an admin instance of Command Prompt:
msiexec /i AcctivateQB.msi /qn /l*v install.log INSTALLFOLDER="C:\Program Files (x86)\Acctivate" INSTALLDESKTOPSHORTCUT="true" ACCTID="loginid" ACCTPASS="password" SERVERNAME="SERVER" INSTANCENAME="ACCTIVATE" SQLUID="sa" SQLPASS="Password" INSTALLATIONTYPE="Server"
Silent Database Upgrade
Some Acctivate updates require an update to the database (see Database Updates. When a database update is required, the user will be prompted to begin the update when logging into an Acctivate company. Some users and hosting providers may prefer to script the database upgrade to more efficiently upgrade multiple company files.
From a command line, you can run Acctivate Database Maintenance and then add the necessary switches and company names to complete the database upgrade.
Start by calling the Acctivate Database Maintenance application and then add the necessary Update command arguments. You can find the application in the root of the Acctivate master directory, named AcctivateDBMaint.exe.
Update Command Arguments:
- /U = Update database
- /C = Company ID
- /QUIET = Errors will be displayed but no informational messages
- /SILENT = Suppress all errors and informational messages
An example of the command to upgrade the company DEMO:
"C:\Program Files (X86)\Acctivate\AcctivateDBMaint.exe" /U /C DEMO
"Database update completed" will appear when the update has finished, unless the
/SILENT command is used.
Install using an existing instance of SQL
The Acctivate installer will install the Express edition of Microsoft SQL Server and create an instanced named "ACCTIVATE", unless a previously installed SQL Server instance exists that is specifically named ACCTIVATE.
If you wish to install Acctivate against an existing instance of SQL not named ACCTIVATE, you can perform a command line installation.
- Download Acctivate and save the installation file.
- Locate the Acctivate installation file and rename the file to setup.exe (NOTE: Simply rename to “setup” if the file extension (i.e. exe) is not visible)
- Open a new Command Prompt window from the Start Menu
- Change Directory (CD) to the location of the Acctivate installer file
- Execute the Acctivate installer using one of the commands below.
SQL Authentication (Preferred for Acctivate)
setup.exe /sqlserver=SERVERNAME\INSTANCE /sqluid:sa /sqlpwd:password
setup.exe /sqlserver=SERVERNAME\INSTANCE /sqltrusted