This article forms part of the Attache Installation and Upgrade process. Following the steps in this article would be as part of an installation/upgrade of Attaché, or as a re-install specifically directed by an Attaché Support engineer to resolve a current issue.
If you are installing or upgrading Attaché, please refer to the Attaché: Installation and Upgrade Guide.
Notes prior to installing or upgrading the Attaché Database Server
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é Server Database is to store your data, in addition it operates as a Windows service and therefore cannot be installed on a Network Attached Storage (NAS) device.
Attaché Database Server should be secured away from general users. This means that 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 the Attaché Database Server on the same computer but in a different directory that is not accessible to Attaché users.
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. After installing Microsoft Visual C++ Redistributable, restart the computer before you continue with the installation.
Attaché Database Server 32-bit and 64-bit (64-bit Recommended)
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. Only install the 64-bit Attaché Database Server on servers that have a dedicated 8GB 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 (https://support.microsoft.com/en-au/kb/827218).
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.
When installing the 64-bit Attaché Database Server, the cache size will default to 1000MB. If required, you can increase or decrease the default cache size to meet your specific needs. See Adjust the Attaché Database Server default cache size.
Stopping all Attaché Services and exiting all users before installing
If Attaché is already installed, or you are upgrading, all users are to logout of Attaché, and all Attaché services should be stopped before proceeding. Doing so ensures that all files are not locked and can be replaced cleanly without a restart of the server. The following services should be stopped 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).
Installing or upgrading 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 the 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're not using "Local Admin" Select Yes.
(Only if you can't use "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.