• 0

AWS and Local SQL DB communication - ASP.NET


Question

limok

Hi,

 

I'm in process of building a web application using ASP.NET 4.5 and C# connecting to a SQL Server database. Eventually I want to deploy the web app and its database to AWS. However, I have another database that will be remain onsite that will feed requests from the web application and store into the web app's database.

 

What are my options for doing this securely and can you provide some guidance?

 

If you need more info then let me know.

 

Cheers, 

Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0
+Kyle

So, you will have the web application in Amazon communicate with your database locally? Is there a real reason the database can't be moved/replicated to AWS? 

 

My suggestion would be to make a tunnel from your local router/firewall to the AWS VPC your application will be housed in. At that point your database should be able to communicate to your web application and vice versa. 

http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_VPN.html#SetUpVPNConnections

Link to post
Share on other sites
  • 0
limok

Thanks for the suggestion, 

 

The reason I went with hosting on AWS was to limit the overall exposure or potential exposure to our system. I'm just not comfortable setting one up just for that.

 

instead I've figured out that I can use WCF to set up a web service to answer requests made from the AWS web app. I can also set IIS and my firewall only to answer calls from the AWS IP address.

 

Cheers, 

Link to post
Share on other sites
  • 0
firey

Why not use Azure and host everything on Azure? Database, WebApp, etc.

  • Like 2
Link to post
Share on other sites
  • 0
limok
9 minutes ago, firey said:

Why not use Azure and host everything on Azure? Database, WebApp, etc.

Can't - SQL server is backbone of current infrastructure. Not going cloud for infrastructure any time soon.

Link to post
Share on other sites
  • 0
firey
14 hours ago, limok said:

Can't - SQL server is backbone of current infrastructure. Not going cloud for infrastructure any time soon.

Azure has full SQL Server/Database no different than using a VPS or something similar. Where I work we started migrating to Azure and have had 0 issues.  0 downtime, 0 database issues (we have 4 SQL Databases on Azure). We also have Azure set to auto-backup the databases plus we regularly do backups. Since it's still SQL you can use SQL Management Studio and connect directly to the DB.

I dunno, just a thought.

  • Like 2
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By News Staff
      Save 97% off the 2021 All-In-One AWS, Cisco & CompTIA Super Certification Bundle
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where you can save 97% off the 2021 All-In-One AWS, Cisco & CompTIA Super Certification Bundle. Become a top-notch, in-demand tech professional with 22 courses and over 240 hours of content on leading it skill certifications — AWS, Cisco, and CompTIA.



      This bundle consists of the following courses:

      AWS CodePipeline DevOps CI/CD Masterclass 2020
      Build a Complete DevOps CI/CD Pipeline with AWS CodePipeline by Deploying Several Web Applications Using AWS CodeStar MPLS Fundamentals: Cisco CCNP & Real World
      Learn What the MPLS Protocol Can Do for Your Network Cisco CCNA 200-301 Bootcamp
      Top-Rated Course to Help You Master Cisco Networking to the CCNA Level & Beyond TOTAL: AWS Certified Database Specialty Exam Prep (DBS-C01)
      Study for the Newest AWS Exam Today! AWS Solutions Architect Associate - 2020 (SAA-C02)
      Everything You Need to Pass the AWS Solutions Architect Certification Exam AWS Cloud Essentials: The Total Course
      Boost Your Earning Potential in Just One Hour with this Crash Course in AWS Cloud Practitioner & Technical Essentials TOTAL: Cloud Computing / CompTIA Cloud+ Cert. (CV0-002)
      Learn the Basics of Cloud Computing & Prepare for the CompTIA Cloud+ Certification Exam The Total CompTIA A+ Certification Core 1 (220-1001) Prep Course
      Kickstart Your IT Career by Acing the Industry-Standard Certification for Security to Cloud, Data Management & More The Total CompTIA A+ Certification Core 2 (220-1002) Prep Course
      e a CompTIA A+ Certified Professional with Expanded Skills on Configurations, Security Software Troubleshooting & Operational Procedures The Total CompTIA Network+ Certification N10-007 Prep Course
      Address the Current & Changing Networking Technologies As a CompTIA Network+ Professional Cisco EIGRP Comprehensive Labs Course
      Configure EIGRP for Real-World & Certification Purposes Cisco CCNP T-Shoot (300-135): The Complete Course
      Get On Course to Earn Your Cisco CCNP Routing & Switching Certification AWS Cloud Migration for IT Professionals
      Design & Implement Migration Strategies to Shift Your On-Premise Infrastructure to the AWS Cloud Google Cloud Platform for AWS Professionals
      Adapt Your AWS Knowledge to the Google Cloud Platform Mastering Jenkins CI with Amazon AWS: Build DevOps Pipeline
      Implement & Integrate Jenkins Continuous Integration with Amazon AWS Beanstalk Using Github AWS Cloud Technologies Masterclass
      Gain a Solid Understanding of the AWS Cloud Technology & Get Your AWS Cloud Practitioner Certification AWS Certified Cloud Practitioner: Essentials Course 2020
      Learn About the AWS Platform, Global Infrastructure, Security & The Core Services AZ-104: Microsoft Azure Administrator - Full Course
      Learn How to Prepare for the Azure 104 Certifications the Right Way Amazon AWS QuickSight, Glue, Athena & S3 Fundamentals
      Make Great Visualizations! Learn Complete Workflow: Data Lake, AWS Athena, AWS Glue, & S3 New Cisco CCNA (200-301) Volume 1: The Complete Course
      All the Main Topics Discussed in Volume 1 of the New CCNA Cisco Press Book New Cisco CCNA (200-301) Volume 2: The Complete Course
      All the Main Topics Discussed in Volume 2 of the New CCNA Cisco Press Book The Total CompTIA Security+ Certification SY0-501 Prep Course
      Ace the Globally-Recognized Exam on Network Threats & Risks Identification, Management, and Mitigation Good to know
      Updates included Length of time users can access this course: lifetime Certification of completion included Redemption deadline: redeem your code within 30 days of purchase For specifications and instructor info please click here.

      Here's the deal:
      This 2021 All-In-One AWS, Cisco & CompTIA Super Certification Bundle normally costs* $4,378, but it can be yours for just $99 for a limited time, that's a saving of $4,279 (97%).

      >> Get this deal, or learn more about it here <<
      See all Online Courses on offer. This is a time-limited offer that ends soon.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      If this offer doesn't interest you, why not check out the following offers:

      The Win Your Dream 2020 Tesla Model 3 Giveaway
      20% off Ivacy VPN subscription with coupon code IVACY20 NordVPN subscription at up to 68% off for a 2 year plan Private Internet Access VPN subscription at up to 71% off Unlocator VPN or SmartDNS unblock Geoblock with 7-day free trial Disable Sponsored posts · Other recent deals · Preferred partner software

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Save 95% off this Complete 2020 Cloud Foundation Certification Bundle
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store where you can save 95% off this Complete 2020 Cloud Foundation Certification Bundle. Learn everything you need to be a certified cloud developer with 42+ hours of prep content on AWS, Azure, Google Cloud and CompTIA.

      This bundle consists of the following courses:



      AWS Certified Cloud Practitioner

      The Amazon Web Services Certified Cloud Practitioner Exam is a fundamental look into the services available with Amazon Web Services. The purpose of this course is to make you aware of AWS services such as EC2, RDS, Elastic Beanstalk, S3, and more. Additionally, this is a great way for sales, managers, developers, and admins alike to become familiar with AWS. If you are looking to get started with Amazon Web Services, then this is the course for you. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support.

      Access 19 lectures & 7.5 hours of content 24/7 Describe basic security & compliance aspects of the AWS platform and the shared security model Define the billing, account management, & pricing models Identify sources of documentation or technical assistance (e.g., whitepapers, support tickets) Describe the AWS Cloud value proposition Describe basic/core characteristics of deploying & operating in the AWS Cloud

      Microsoft Azure Fundamentals (AZ-900)

      This series will help you prepare for the Exam AZ-900: Microsoft Azure Fundamentals. This exam is designed for candidates looking to demonstrate foundational-level knowledge of cloud services and how those services are provided with Microsoft Azure. The exam is intended for candidates with non-technical backgrounds, such as those involved in selling or purchasing cloud-based solutions and services, or who have some involvement with cloud-based solutions and services, as well as those with a technical background who have a need to validate their foundational-level knowledge around cloud services.

      Access 54 lectures & 15.6 hours of content 24/7 Understand cloud concepts Learn about core Azure services Master security, privacy, compliance, & trust Understand Azure pricing & support

      Google Cloud Platform: Associate Cloud Engineer

      This Google Associate Cloud Engineer course was specifically designed to provide a refresher of the topics of the GCP Associate Cloud Engineer Exam. This course is designed for experienced GCP engineers that need a refresher of the objectives before taking the exam. If you need more hands-on help then taking the additional courses would be wise before taking the exam. During the course, we will provide insight into the GCP Cloud Engineer exam and walk through main exercises around managing a GCP Cloud.

      Access 34 lectures & 8.06 hours of content 24/7 Manage your GCP Cloud environment more efficiently Learn how to use the GCP gcloud commands needed for the passing of this exam Learn how to size App Engine & Bigquery Learn how to Secure Compute Engine Learn the required Kubernetes commands. Understand Billing in GCP How to secure the GCP cloud w/ IAM & Cloud Identity

      CompTIA Cloud+ (CV0-002)

      Cloud+ covers the increased diversity of knowledge, skills and abilities required of system administrators to validate what is necessary to perform effectively in data center jobs. It includes the new technologies to support the changing cloud market as more organizations depend on cloud-based technologies to run mission-critical systems, and hybrid and multi-cloud have become the norm. CompTIA Cloud+ views cloud-based infrastructure services as an increasingly important piece of an organization’s IT systems.

      Access 53 lectures & 11.56 hours of content 24/7 Get familiar w/ the new technologies supporting the changing cloud market Analyze system requirements to successfully execute workload migrations to the cloud Determine proper allocation of cloud resources & apply necessary changes Troubleshoot capacity, automation, connectivity & security issues related to cloud implementations Good to know
      Updates included Length of time users can access after purchase: lifetime Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and instructor info please click here.

      Here's the deal:
      This Complete 2020 Cloud Foundation Certification Bundle normally costs* $1,180 but it can be yours for just $49.99 for a limited time, that's a saving of $1,130.01 (95%) off the price.

      >> Get this deal, or learn more about it here <<
      See all Online Courses on offer. This is a time limited deal.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      If this offer doesn't interest you, why not check out the following offers:

      The Win Your Dream 2020 Tesla Model 3 Giveaway
      The Nintendo Gaming Bundle Giveaway 20% off Ivacy VPN subscription with coupon code IVACY20 NordVPN subscription at up to 68% off for a 2 year plan Private Internet Access VPN subscription at up to 71% off Unlocator VPN or SmartDNS unblock Geoblock with 7-day free trial Disable Sponsored posts · Other recent deals · Preferred partner software

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Get the Complete Computer Networking eBook & Video Course Bundle for only $29.99
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store where you can save 95% off this Complete Computer Networking eBook & Video Course Bundle. Attain systems efficiency & security with 14+ hours of video content and 5 comprehensive e books on DevOps, Programming, AWS, CCNA, and more.



      This bundle consists of the following courses:

      The Ultimate Kubernetes Bootcamp by School of Devops [Video]
      Prepare for the CKA Exam — Master Container Orchestration with Kubernetes One Step at a Time AWS Certified Advanced Networking: Specialty Exam Guide [eBook]
      Build Your Knowledge & Technical Expertise as an AWS-Certified Networking Specialist Hands-On Network Programming with C [eBook]
      Learn Socket Programming in C & Write Secure and Optimized Network Codes Analyzing Network Traffic with Wireshark 2.6 [Video]
      Delve Into Network Traffic & Analyze Individual Protocol Data Units Active Directory Administration Cookbook [eBook]
      Actionable, Proven Solutions to Identity Management & Authentication on Servers and in the Cloud Hands-On PowerShell for Active Directory [Video]
      Use PowerShell for Active Directory to Eliminate Manual Labor with Quick Automation Tasks & Functions Effective Jenkins: Getting Started with Continuous Integration [Video]
      Learn Continuous Integration, Automate Your Jenkins Projects & Get Continuous Feedback for Your Upstream/Downstream Projects Hands-On Kubernetes Networking [Video]
      Unravel the Mystery of Networking in Your Kubernetes Cluster in a Pragmatic Manner CCNA Cyber Ops SECOPS: Certification Guide 210-255 [eBook]
      Develop Your Cybersecurity Knowledge to Obtain CyberOps Certification Hands-On Linux for Architects [eBook]
      Design & Implement Linux-Based IT Solutions Good to know
      Updates included Length of time users can access after purchase: lifetime Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and author info please click here.

      Here's the deal:
      This Complete Computer Networking eBook & Video Course Bundle normally costs* $746 but it can be yours for just $29.99 for a limited time, that's a saving of $716.01 (95%) off the price.

      >> Get this deal, or learn more about it here <<
      See all Online Courses on offer. This is a time limited deal.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      If this offer doesn't interest you, why not check out the following offers:

      The Win Your Dream 2020 Tesla Model 3 Giveaway
      The Nintendo Gaming Bundle Giveaway 20% off Ivacy VPN subscription with coupon code IVACY20 NordVPN subscription at up to 68% off for a 2 year plan Private Internet Access VPN subscription at up to 71% off Unlocator VPN or SmartDNS unblock Geoblock with 7-day free trial Disable Sponsored posts · Other recent deals · Preferred partner software

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.

    • By News Staff
      Hands-On AWS Penetration Testing with Kali Linux ($35.99 Value) - free download
      by Steven Parker

      Claim your complimentary eBook ($35.99 value) for free, before end of day Friday, August 28.



      What's it about?
      Identify tools and techniques to secure and perform a penetration test on an AWS infrastructure using Kali Linux

      The cloud is taking over the IT industry. Any organization housing a large amount of data or a large infrastructure has started moving cloud-ward — and AWS rules the roost when it comes to cloud service providers, with its closest competitor having less than half of its market share. This highlights the importance of security on the cloud, especially on AWS. While a lot has been said (and written) about how cloud environments can be secured, performing external security assessments in the form of pentests on AWS is still seen as a dark art.



      This book aims to help pentesters as well as seasoned system administrators with a hands-on approach to pentesting the various cloud services provided by Amazon through AWS using Kali Linux. To make things easier for novice pentesters, the book focuses on building a practice lab and refining penetration testing with Kali Linux on the cloud. This is helpful not only for beginners but also for pentesters who want to set up a pentesting environment in their private cloud, using Kali Linux to perform a white-box assessment of their own cloud resources. Besides this, there is a lot of in-depth coverage of the large variety of AWS services that are often overlooked during a pentest — from serverless infrastructure to automated deployment pipelines.

      By the end of this book, you will be able to identify possible vulnerable areas efficiently and secure your AWS cloud environment.

      Features

      Efficiently perform penetration testing techniques on your public cloud instances Learn not only to cover loopholes but also to automate security monitoring and alerting within your cloud-based deployment pipelines A step-by-step guide that will help you leverage the most widely used security platform to secure your AWS Cloud environment This free offer expires on Friday, August 28.

      How to get it
      Please ensure you read the terms and conditions to claim this offer. Complete and verifiable information is required in order to receive this free offer. If you have previously made use of these free offers, you will not need to re-register. While supplies last!

      >> Hands-On AWS Penetration Testing with Kali Linux ($35.99 Value) - free download <<
      Offered by Packt Publishing, view their other free resources. Expires Aug 28.

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here, but be aware that these are all time-limited offers. If you are uncomfortable sharing your details with a third-party sponsor, we understand. Or via our preferred partner:

      How can I disable these posts? Click here.

      Disclosure: A valid email address is required to fulfill your request. Complete and verifiable information is required in order to receive this offer. By submitting a request, your information is subject to TradePub.com's Privacy Policy.

    • By News Staff
      This Complete AWS eBook & Video Course Bundle discounted to 95% off
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where for only a limited time you can save 95% off the Complete AWS eBook & Video Course Bundle. Master the world's biggest web server with 5 eBooks and 13+ hours of video content on Serverless Programming, Machine Learning, Cloud Design, and more all on AWS..



      What's the deal?
      This deal consists of the following courses:

      Serverless Programming Cookbook [eBook]
      Practical Solutions to Building Serverless Applications Using Java & AWS AWS Certified SysOps Administrator: Associate Guide [eBook]
      Your One-Stop Solution for Passing the AWS SysOps Administrator Certification Mastering Machine Learning on AWS [eBook]
      Gain Expertise in ML Techniques with AWS to Create Interactive Apps DevOps: CI/CD using AWS CodePipeline & Elastic Beanstalk [Video]
      Confidently Design a CI/CD Pipeline for Your Own Web Applications AWS Certified Developer: Associate Guide [eBook]
      Learn from the AWS Subject-Matter Experts, Explore Real-World Scenarios, & Pass the AWS Certified Developer-Associate Exam Implementing Cloud Design Patterns for AWS [eBook]
      Create Highly Efficient Design Patterns for Scalability, Redundancy, & High Availability in the AWS Cloud Reliability & Resilience on AWS [Video]
      A Crash Course on Achieving Application Resilience & Reliability on AWS AWS Lambda & The Serverless Framework: Hands-On Learning! [Video]
      Learn Lambda Real World Integrations with Amazon Web Services Design Serverless Architecture with AWS & AWS Lambda [Video]
      Build & Manage Secure Serverless Applications on AWS AWS CloudFormation Master Class [Video]
      Write Complete AWS CloudFormation Templates Using YAML Good to know
      Length of time users can access courses: Lifetime Certification of completion included Redemption deadline: redeem your code within 30 days of purchase For full details, terms, and instructor info for the above courses, click here.

      What's the benefit?
      This Complete AWS eBook & Video Course Bundle normally costs $662, but you can pick this up for just $29.99 for a limited time, that's a saving of $632.01 (95%) off the normal price!

      >> Get this deal, or learn more about it here <<
      See all discounted Online Courses on offer. This is a time-limited deal.
      Get $1 credit for every $25 spent · Give $10, Get $10 · 10% off for first-time buyers.

      Not for you?
      If this offer doesn't interest you, why not check out the following offers:

      The Nintendo Gaming Bundle Giveaway 20% off Ivacy VPN subscription with coupon code IVACY20 NordVPN subscription at up to 68% off for a 2 year plan Private Internet Access VPN subscription at up to 71% off Unlocator VPN or SmartDNS unblock Geoblock with 7-day free trial Disable Sponsored posts · Other recent deals · Preferred partner software

      Disclosure: This is a StackCommerce deal or giveaway in partnership with Neowin; an account at StackCommerce is required to participate in any deals or giveaways. For a full description of StackCommerce's privacy guidelines, go here. Neowin benefits from shared revenue of each sale made through our branded deals site, and it all goes toward the running costs.