Installing SQL Server

Installing SQL Server

SQL Server Setup

The .Net 4.8 framework and C++ Redistributables MUST be installed on the server machine prior to SQL installation. See Prerequisites for further details.

SQL Server Express

The instructions below are provided to assist smaller organisations to install SQL Express 2022.  If further support or assistance is required from Argos, that may be billable.
The latest version of SQL Server Express can be freely downloaded from the web at. SQL Server Express has limitations on both the size of the database, and the memory capacity. 
You will be required to have a Microsoft account to download SQL express.

SQL Server

Where SQL Server installations are required, it is assumed that the IT provider will have sufficient knowledge of SQL server to install and maintain the server, therefore any assistance or support may be billable.    
Note: The section ‘configuring the server surface area’ may be useful as a guideline for the server settings required by the Argos application.

Configure SQL Server

Allow Remote Connections

This step is required if you are connecting to the SQL Server over the network.

1. Start | Programs | Microsoft SQL Server 2014 | Configuration Tools | SQL Server Configuration Manager

2. Open the SQL Server Network Configuration (selecting the appropriate 32/64 bit) and select Client Protocols / Protocols.

 

3. Right Click on TCP/IP and select ‘Enable’

4. The below message will appear:

 

Click [OK]

Automatic Service Start

This step ensures the SQL Server runs as a service each time the machine boots up.

1. Next click on the SQL Server Services menu item:

 
2. Double click on the SQL Server Browser to produce the following dialog:


 

3. Switch to the ‘Service’ tab

4. Select the Start Mode, and change this to Automatic

Click [Apply]

The completed dialog will now appear as below:

 

You should now restart the SQL Server or Reboot the machine.  

The server is now setup to allow remote connections via TCP/IP and will appear in the list of available servers on the network.


    • Related Articles

    • Argos Server Installation

      Purpose The Argos Server allows Batch Processes to run on a separate to Client Application install. When server application is running Batch Processing will prompt user to process on the server or the client application. If server is selected Batch ...

    • Installing Argos Internal API

      The Argos Internal API is used to power the Vault and Bailment applications. Note, this is available from Argos v6.0 onwards Installation Types The installer can be used to install a production instance of the Argos Internal API. Instructions to ...

    • Configure SQL Server Authentication

      SQL Server Access for Argos Users This requires that the SQL installation includes management tools so SQL Server Management Studio Express Edition must be installed. Ensure you are logged in as an Administrator. There are three options are available ...

    • Installing Argos Bailment Website

      Installing Argos Bailment Website Ensure ALL users are logged out of the Bailment Website. Double click on the "Setup" icon in the Bailment Web folder of the latest Argos Vault Release, \Bailment.Web. Refer to the section Upgrading Argos Vault for ...

    • Installation Prerequisites

      Prerequisites The following section outlines the third-party applications required to successfully run Argos. The below applications are not provided as part of the Argos application and it is the responsibility of the client to purchase/licence, ...