How do I install AYS on Amazon AWS Lightsail?

At Your Service has been tested on the Amazon AWS Lightsail platform. This allows you to run the At Your Service – Repair Center software and database server fully in the cloud, with only minimal client hardware.

The following are basic steps to set up an AWS Lightsail server and get started:

Note

At Your Service Software, Inc. does not provide support for installing, administering, or securing cloud-hosted servers as described in this article. Please consult a local IT service provider, Amazon and/or Microsoft for this service.

Create an account and profile with Amazon at https://lightsail.aws.amazon.com

On your dashboard you should see a blank work area, with no instances created, and some tabs along the top.

Click on “Create an Instance” to create a Windows Server to run AYS.

Select the zone closest to your geographic area. Please note that all servers you create (database and Windows Remote Desktop host) should be located in the same zone.

Choose “Microsoft Windows” and choose the “OS Only” blueprints. Select “Windows Server 2016”

As of mid 2019, AYS Lightsail is offering several tiers of server. Here are some suggested configurations:

RAMCPUStorageTransfer
4 GB2 vCPU80 GB SSD4 TB
8 GB2 vCPU160 GB SSD5 TB
16 GB4 vCPU320 GB SSD6 TB
32 GB8 vCPU640 GB SSD7 TB

While some lower end servers are available, the minimum suggested tier to run AYS well is the 4 GB + 2 vCPU tier. It has been tested with 10 simultaneous user sessions. Note, any additional applications and workloads run by the server in addition to AYS will likely require higher powered instances.

Click “Create instance” and you will be returned to the dashboard. AWS will create and provision your server over the next few minutes.

Set up your server

Click on the server name in your instance screen.

You can connect to the instance using the orange button, or using the Remote Desktop Client installed on your local machine.

If you use the RDP client, connect to the Public IP address in the upper right as shown by the arrow. This address will change when the instance is stopped and restarted, but you can create a static IP for the instance using the Lightsail Dashboard “Networking” tab.

Click on “Show default password” to see the complex password automatically generated for your instance.

Log on as Administrator using the provided password.

You may configure and administer your server for AYS as you would a local machine.

As Administrator, you should do the following:

  • Create Users
  • (optional) Create a Local group for AYS users
  • Install AYS via the installer and grant permission to AYS folder
  • Install database connector drivers if required
  • Set up and configure a SQL server instance
  • Install other software, such as Quickbooks or PDF applications

You can use either MySQL or Microsoft SQL Server servers hosted on the Lightsail services. While it is technically possible to connect to other services (such as EC2 RDS) from the Lightsail Windows Server, only Lightsail hosted servers will be discussed here.

You can either create a managed or unmanaged (self-administered) server on the platform. MySQL is available in both cases but Microsoft SQL Server is available only as an unmanaged server. Managed servers are pre-configured and have automatic backup and update solutions in place.

Managed database (MySQL)

Select the Lightsail dashboard and choose the Databases tab

Click the “Create instance” button

MySQL has been tested on AWS Lightsail and is supported with both version 5.x and 8.0.15. Note that PostgreSQL is not supported by AYS.

Choose an instance according to your expected client load and budget. Here are some of the available tiers:

RAMCPUStorageTransfer
1 GB1 vCPU40 GB SSD100 GB
2 GB2 vCPU80 GB SSD100 GB
4 GB4 vCPU120 GB SSD100 GB
8 GB8 vCPU240 GB SSD200 GB

The smallest 1 GB, 1 vCPU Managed MySQL server has been tested with 10 simultaneous user sessions, and performs well.

Click on the database once it has been provisioned and you will see a screen like this

Note the endpoint and the “dbmasteruser” password generated by the server. Within your Windows (AYS) server, you can install the MySQL Workbench and use this information set up users in order to create and access your server.

You can create a System DSN with this information as Administrator, and all users will be able to use it to connect to the database.

Self-administered database (MySQL or MS SQL Server Express)

You can create an instance with a Linux or Windows host and manually install MySQL if you wish some capability that is not included in the managed database. You can also install MS-SQL Server (Standard or Enterprise) in a Windows instance. These options are not described here.

If you wish Microsoft SQL Server express the options provided at this time are:

RAMCPUStorageTransfer
2 GB1 vCPU60 GB SSD3 TB
4 GB2 vCPU80 GB SSD4 TB
8 GB2 vCPU160 GB SSD5 TB
16 GB4 vCPU320 GB SSD6 TB
32 GB8 vCPU640 GB SSD7 TB

Choose the Microsoft Windows blueprints, and the “Apps + OS” blueprint option.

You will have to follow a similar process as above in setting up the Windows server in order to run the SQL Express server.

Important

This section describes only basic Remote Desktop (Terminal Server) setup. It is much better to set up a Remote Desktop Gateway server and implement stronger security policies to keep your server and information safe.

Windows Server includes 2 CAL (client access licenses) to connect to the server for administrative use. You will have to purchase and install licenses for the users you want to connect to the server.

Installing Remote Desktop Server and the Management tools

Click on the Start menu and launch the Server Manager. On the dashboard on the right, click “Manage” and choose “Add Roles and Features”

In the following Wizards, choose “Role-based or feature-based installation”

In Server selection, your server should be visible, select it and choose next

The server roles page will show a list. Select “Remote Desktop Server” from the list and choose next

On the next screen, choose next, there is nothing to select.

Press Next – you can now select the options to install on the server. Select and check Remote Desktop Licensing.

As soon as you select the checkbox, a confirmation screen will show. Be sure to select “Include management tools (if applicable)” and press “Add features”. On the next screen, click “Install”

Select also Remote Desktop Session Host and also confirm the additional packages and management tools required.

Note

As mentioned above, you could at this point also select Remote Desktop Connection Broker, and Remote Desktop Gateway. How to set up these services is not described here.

Configuring the RDS License Server

The local Remote Desktop Server will need to access a license server to check its CAL status, and none is configured.

Launch the Windows Local Group Policy Editor by selecting Start – Run and type gpedit.msc

Choose the path:
Local Computer Policy

  • Computer Configuration
    • Administrative Templates
      • Windows Components
        • Remote Desktop Services
          • Remote Desktop Session Host
            • Licensing

The default licensing settings are unconfigured.

Double-click “Set the Remote Desktop licensing mode”, click “Enabled” and choose whether you have purchased “Per user” or “Per device” licenses. Click Apply and then OK.

Consult Microsoft for the differences between licensing modes. Here is some of their documentation explaining CALs

Select “Use the specified Remote Desktop license servers”, click “Enabled” and enter “localhost” for the field “License servers to use”. Click “Apply” and then “OK”.

Now you can install your Remote Desktop Server CALs purchased from Microsoft and the server will use them to allow licensed users to connect.

Coming soon

Managed databases

If using a managed backup option, you can back up the database to a snapshot or roll it back to any point in time using the Lightsail interface.

Click the Database instance and select the “Snapshots & restore” tab. Here you can create a one-click snapshot of the entire server. If necessary you can create an entirely new instance from this snapshot (or migrate to a larger instance if your capacity is reached)

You can also roll back your database state to any time within the last week. Choose the time and click “Restore to new database”.

Unmanaged databases

You will need to create your own backup strategy for unmanaged databases using the SQL tools you install on the Windows host machine.