Connecting to a Microsoft SQL Server database with Amazon RDS in Cayoosft Guardian

Cloud-based deployment option; consider linking from installation docs

To create and connect a Microsoft SQL Server database with Amazon RDS for Cayosoft Guardian, ensure you have the following set up:

• AWS Account with necessary permissions to create and manage RDS instances.  If you don't already have an account, follow the Setting Up Your AWS Environment tutorial for a quick overview.
• Amazon RDS Security Group that allows inbound traffic from the Cayosoft Guardian server.
• Microsoft SQL Server Management Studio (SSMS)

For more details on how to create an Amazon RDS SQL server instance and connect to the Microsoft SQL server, see Create and Connect to a Microsoft SQL Server Database with Amazon RDS.

For Cayosoft Guardian system requirements, see software requirements.

Connect to a Microsoft SQL Server database with Amazon RDS in Cayosoft Guardian

1. Open the Cayosoft Guardian web portal.
2. Navigate to Settings > System Databases.
3. Select the database and click Properties.
4. Enter credentials using the ones that you have used when connecting to a Microsoft SQL Server Database with Amazon RDS:
   1. SQL Server Name (Required) – Enter the SQL Server instance name (e.g., Host\Instance).
   2. Database Name (Required) – Specify the name of the database (e.g., Cayo.Guardian.History).
   3. Database Path – Provide the directory path or full path to the MDF file (if applicable).
   4. SQL Server Authentication – If checked, you need to enter:
      • Login Name – The SQL Server username.
      • Password – The corresponding password.
   5. Additional connection Parameters – Optional parameters (e.g., Connection Timeout=30;Encrypt=False).
   6. Data copy options (Required) – Choose whether to copy history data.
   7. Create the specified database if not present on the SQL Server – Select Yes or No as needed.
5. Click Save to apply the configuration.