• About Us
  • Blogs
  • Contact Us

Seamless Deployment of Microsoft AD, SQL Server, and IIS on AWS with Integrated Backup and Automation

The client, a mid-sized enterprise, required a scalable and secure cloud infrastructure for their Windows-based services. Their existing on-premises environment involved Active Directory (AD), SQL Server databases, and an IIS web server for hosting internal applications.

Client:

Doctory

Date:

09/07/2024

Website:

doctory.me

Category:

Cloud Consultancy

Managed Services

About Customer

Doctory

The client, a startup, required a scalable and secure cloud infrastructure for their Windows-based services. Their existing on-premises environment involved Active Directory, SQL Server databases, and an IIS web server for hosting internal applications.

Deliver the right solutions on the leading cloud platform

Cloud Consultancy

Unmatched due to SUDO’s wide knowledge and experience with the top three public cloud providers: AWS, Microsoft Azure and Google Cloud, we provide cloud solutions that work uniquely in line with your business model. With our experienced professionals based in Dubai, UAE you’ll be able to gain deep insights into critical trends and opportunities in cloud technologies, access real-time data analytics, and modernize your entire infrastructure.⁣

Customer Challenge

The client needed to migrate their Windows workloads to AWS while ensuring seamless integration with AWS services for backups, storage, and automation. They also required a cost-effective, automated solution for managing database scheduling and backup operations. Some business challenges are listed below:

  1. Content Delivery
  2. High Availability
  3. Fault Tolerance
  4. Security

 

SUDO Solution

We deployed Microsoft Active Directory (AD) on AWS to maintain the client’s existing user management structure. SQL Server was implemented to host their critical business databases, and a Windows Server with IIS was configured for their web applications. To ensure data safety and compliance, AWS Backup was integrated to automate backup operations, while assets such as web files and media were stored on Amazon S3.

For database scheduling, we utilized AWS Lambda, which triggered and managed regular SQL Server tasks such as backups and maintenance, while RDS handled the database backend efficiently. The entire solution was designed with scalability and future growth in mind, allowing the client to expand their infrastructure with ease.

AWS Services Ecosystem

The entire solution was deployed following IaC tool: Terraform

SUDO Solution Architecture Diagram

Backend Architecture

Results & Benefits

  • Enhanced Security and Reliability: By migrating to AWS, the client benefited from enhanced security features and automated backup systems.
  • Cost Efficiency: The use of Lambda for scheduling and automation significantly reduced the operational overhead associated with manual database tasks.
  • Scalable Architecture: The solution provided the client with a flexible and scalable cloud environment, allowing for easy expansion of their workloads.
  • Improved Performance: The integration of IIS on a dedicated Windows server with SQL Server and optimized storage via S3 ensured faster response times for their web applications.