This article forms part of the Attaché installation and upgrade process. Follow the steps in this article as part of an installation or upgrade of Attaché, or as a re-install specifically directed by an Attaché Support engineer to resolve a current issue.
📌Note: If you are installing or upgrading Attaché, please refer to the Attaché: Installation and upgrade guide.
Before you install or upgrade
Review the following notes before installing or upgrading Attaché Database Server.
Service and location requirements
Attaché Database Server operates as a Windows service and must be installed physically at the computer where it will run.
Although the primary function of Attaché Database Server is to store your data, because it operates as a Windows service it cannot be installed on a Network Attached Storage (NAS) device.
Attaché Database Server should be secured away from general users. It should be located on a computer (or directory) that will not be shared by all users.
Attaché Software recommends installing Attaché Database Server on a computer in the network that is separate from the computer that runs the Attaché application.
The Database Server may be installed on any local drive on that computer. If this is not feasible, install Attaché Database Server on the same computer but in a different directory that is not accessible to Attaché users.
Microsoft Visual C++ Redistributable
When installing Attaché Database Server, you may be prompted to install Microsoft Visual C++ 2015 Redistributable. This is needed to run Attaché and is compatible with all supported operating systems.
⚠️Important: After installing Microsoft Visual C++ Redistributable, restart the computer before continuing with the installation.
32-bit and 64-bit versions
Two versions of Attaché Database Server are available: 32-bit and 64-bit.
The 64-bit version allows more RAM to be available for running Attaché Server processes, leading to increased server performance and should resolve any out-of-memory errors when dealing with large datasets or running large reports. These performance improvements will only occur if your server has sufficient RAM available.
⚠️Important: Only install the 64-bit Attaché Database Server on servers that have a dedicated 8 GB RAM or more for Attaché.
Which version should you install?
You must select the appropriate version for your server operating system. To check your server operating system version, refer to the Microsoft support documentation.
If your server is running a 32-bit operating system, you must install the 32-bit Attaché Database Server.
If your server is running a 64-bit operating system, you can install either the 32-bit or 64-bit Attaché Database Server.
📌Note: When installing the 64-bit Attaché Database Server, the cache size will default to 1000 MB. If required, you can increase or decrease the default cache size to meet your specific needs.
Stop all Attaché services and exit all users
If Attaché is already installed, or you are upgrading, all users must log out of Attaché, and all Attaché services must be stopped before proceeding. Doing so ensures that all files are not locked and can be replaced cleanly without a restart of the server.
Stop the following services through the Windows Services console (services.msc) on the Attaché data server:
Attaché Database Server.
Attaché API Service.
Attaché Cloud Connector - Message Processor (will be decommissioned in Attaché 20.1).
Attaché Cloud Connector - Message Relay (will be decommissioned in Attaché 20.1).
Attaché Service API (will be decommissioned in Attaché 20.1).
Install or upgrade Attaché Database Server on Windows 10 or Windows 11
On the physical Attaché data server computer, right-click on the installation file (AttacheServer.exe) and select Run as administrator.
If prompted by User Account Control, select Yes.
If prompted by Windows Smart Screen, click More info and then choose Run anyway.
The Installation Wizard will now run. When prompted, click Next.
Select Custom and then click Next.
Select the location to install Attaché Database Server and then click Next.
📌Note: If upgrading, the location will be the existing AttacheServer folder.
When prompted to use a Windows Account to run the database service, select No if you are already using a "Local Admin" Windows account to do the installation (skip to step 9). Or, if you are not using a "Local Admin" account, select Yes.
(Only if you cannot use a "Local Admin" account as above) Enter the details of your domain account and then click Next.
Select Install.
Once the installation is complete, click Finish.