VM Configuration

This guide is is intended for knowledgeable IT staff only.

1. Provision an Azure VM

   • SQL Server Web Edition, at least 2 cores, at least 8GB mem.

   • Enable HTTPS (443), FTP (21,50000-50100), and RDP (3389) Endpoints via network security group

   • Copy or use network security groups for DB01 or DB04

   • Create additional disks for F:\data and G:\logs

2. Copy vmsetup.ps1 and renew.ps1 and Offsite_to_B.cmd files to the F:\config directory

3. Edit the Offsite_to_B.cmd file to update the {key} 

4. Edit the renew.ps1 file to contain the correct $dns value (i.e. db01.shipperxl.com)

5. Execute vmsetup.ps1  (with parameters)

6. During this process, you will perform manual steps, including running the following installations and scripts

   • SQL Server Reporting Services 2022

   • Report User (script)

   • Archive (script). Yearly, first Saturday of every January

   • Backups (script). Every hour.

   • Maintenance (script). Every Saturday at 12:00 PM UTC

   • CreationQueue (script). Runs on DB04 only. Every 15 minutes.

   • Linked Server (script). Only for sxl_hurkin server.

7. Run GitHub actions:

   • Run reports deployment

   • Run web service deployment

8. Install ShipperXL Desktop locally. 

Troubleshooting

• https://learn.microsoft.com/en-us/answers/questions/1192910/powershell-5-1-not-accepting-keyboard-input-when-u