• 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
This topic is now closed to further replies.
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By News Staff
      Save 94% off a lifetime membership to Whizlabs Online Certifications
      by Steven Parker



      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where you can save 94% off a lifetime membership to Whizlabs Online Certifications. Get lifetime access to affordable world-class certification training courses and gain new, essential industry skills.

      Are you a practicing professional but wanting to learn more? Learn new skills and knowledge at your own pace with Whizlabs. Whizlabs is a pioneer among online training providers across the world. They provide online certification training in various disciplines such as Cloud Computing, Java, Big Data, Project Management, Agile, Linux, CCNA, and Digital Marketing. Launched in 2000, Whizlabs has helped more than 3 million professionals and 100+ companies across the world to succeed in their careers with multitudes of courses. If you want to boost your career or grow in your current field, then sign up to Whizlabs now!

      Access various courses on AWS, Microsoft, Google Cloud, Java, Linux & more Get certifications & validate and demonstrate your new skills Learn from subject-matter experts & certified professionals Get regularly updated content What's the benefit?
      Lifetime membership to Whizlabs Online Certifications normally costs $4,499, but you can pick it up for just $239.99 for a limited time - that represents a saving of $4,259.01 (94%) off. For a full description, specs, and instructor info, click the link below.

      Save 94% off a lifetime membership to Whizlabs
      Not for you?
      That's OK, there are other deals on offer you can check out here.



      Enter giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      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 Abhay V
      Amazon reports blockbuster Q1 2021 earnings, net sales at $108.5 billion
      by Abhay Venkatesh



      A day after Microsoft, Apple, Samsung, and other tech companies reported their quarterly financial results, Amazon today announced its quarterly earnings for the first quarter of 2021 ending March 31. The company reported net sales of a whopping $108.5 billion, up by 44% compared to the same quarter last year. Operating income more than doubled year-over-year to $8.9 billion, with the company continuing to grow faster than ever during the pandemic. Net income stood at $8.1 billion, up from $2.5 billion in Q1 2020.

      The firm provided a few highlights that included subscription stats for its services and updates about its various support programs. The company says that there are “more than 200 million” Prime members worldwide, adding that it will be holding its Prime Day deals event in the second quarter for these members.

      Prime Video, its content streaming service, is now 10 years old and has over 175 million members. The company also noted that the service will be the first to “secure an exclusive national broadcast package from the NFL” as it becomes the exclusive platform for Thursday Night Football beginning in 2023, which is a 10-year deal. The company did not provide any usage stats for Amazon Music.

      As for Amazon Web Services (AWS), the company’s cash cow, the service turns 15 years old and is a $54 billion annual sales run rate business. This marks a 32% increase year-over-year, the company adds. It also highlighted the launch of its second full region in Japan, an expansion of its existing Osaka Local Region.

      Amazon adds that it aims to use 100% renewable energy by the year 2025, cutting five years off its earlier 2030 target. In India, it aims to induct 100,000 electric vehicles into its delivery fleet by 2030, with 10,000 vehicles expected to make it to its fleet by 2025.

      As for the second quarter, the company expects net sales to be between $110.0 billion and $116.0 billion – up from the $88.9 figure for Q2 2020 – growing by 24% to 30%. It also expects net income to be between $4.5 billion and $8 billion.

    • By News Staff
      Save 98% off a lifetime membership to Whizlabs Online Certifications
      by Steven Parker

      Today's highlighted deal comes via our Online Courses section of the Neowin Deals store, where you can save 97% off a lifetime membership to Whizlabs Online Certifications. Get lifetime access to affordable world-class certification training courses and gain new, essential industry skills.



      Are you a practicing professional but wanting to learn more? Learn new skills and knowledge at your own pace with Whizlabs. Whizlabs is a pioneer among online training providers across the world. They provide online certification training in various disciplines such as Cloud Computing, Java, Big Data, Project Management, Agile, Linux, CCNA, and Digital Marketing. Launched in 2000, Whizlabs has helped more than 3 million professionals and 100+ companies across the world to succeed in their careers with multitudes of courses. If you want to boost your career or grow in your current field, then sign up to Whizlabs now!

      Access various courses on AWS, Microsoft, Google Cloud, Java, Linux & more Get certifications & validate and demonstrate your new skills Learn from subject-matter experts & certified professionals Get regularly updated content Good to know
      Length of time users can access this course: lifetime This plan is only available to new users Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and instructor info, click here.

      What's the benefit?
      Lifetime membership to Whizlabs Online Certifications normally costs* $4,499, but you can pick it up for just $129.99 for a limited time - that represents a saving of $4,369.01 (97%) off.

      Spring Sale Promo
      Ends today April 13, for every $75 spent, get $10 in store credit.

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

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here.



      Enter giveaways: Polycade Home Arcade | $5K in cash | $10K in Crypto Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      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 Hamza Jawad
      SQL Server Big Data Clusters CU10 brings important new capabilities
      by Hamza Jawad



      With the release of SQL Server 2019, Microsoft brought Big Data Clusters (BDC) for customers as a way to utilize both structured and unstructured data. Running exclusively on Linux containers that are hosted on Kubernetes, these clusters can be deployed both on-premise and on the cloud. Last year, the tech giant released the cumulative update 5 (CU5) for SQL Server 2019, focusing on expanding capabilities offered through BDC.

      Today, Microsoft has unveiled the SQL Server Big Data Clusters CU10 release. With this update, a few new important capabilities have been introduced. These have been highlighted as follows:

      Notably, when it comes to base image upgrading, the documentation for the CU10 release states that due to the stricter security requirements of Ubuntu 20.04, users may face issues if they attempt to use BDC to connect to SQL Server instances before SQL Server 2017. If such a case arises, they should refer to the following solution.

      When upgrading existing BDC, the new CU10 images will be utilized once the usual in-place upgrade to the CU has been performed. Additionally, High Availability capabilities for Hadoop's key management service (KMS) components further improves the Encryption at Rest feature set. After the upgrade, all namenode pods will have a KMS, not only offering increased high availability, but also providing a performance boost for encryption operations on encryption zones.

    • By News Staff
      Get this Backend Developer Bootcamp Bundle for only $29.99
      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 96% off this Backend Developer Bootcamp Bundle. This 31-hour course bundle takes you behind the scenes of web development: C#, SQL, .NET Core, and more.



      This bundle includes the following courses:

      Learn C# By Building Applications
      Understand the Concepts of C#6 & C#7 and Use Them to Build Real World .NET Console Apps Master C# and SQL by Building Applications
      Learn How to Build Real-World Applications Using C# & SQL Beginner Object Oriented Programming in C# and .NET Core
      Learn Object-Oriented Programming Fundamentals & Climb Up the Developer Hierarchy Learn ASP.NET Core and SQL by Writing ToDo API
      Write an API with Step-by-Step Instructions Using ASP.NET Core, SQL Server, & T-SQL Microsoft SQL Server & T-SQL Course for Beginners
      Learn about the Benefits of SQL & How SQL Server Stores Data Good to know
      Length of time users can access this course: lifetime Certificate of completion included Redemption deadline: redeem your code within 30 days of purchase For a full description, specs, and instructor info, click here.

      Here's the deal:
      This Backend Developer Bootcamp Bundle normally costs $995, but you can pick it up for just $29.99 for a limited time - that represents a saving of $965.01 (96%) off.

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

      Not for you?
      That's OK, there are other free eBooks on offer you can check out here.



      Home Gym Giveaway | Bitcoin (BTC) Investment Giveaway Ivacy VPN - 5 year subscription for just $1 per month NordVPN - 2 year subscription at up to 68% off Private Internet Access VPN - subscriptions at up to 71% off Unlocator VPN or SmartDNS - unblock Geoblock with 7-day free trial Neowin Store for our preferred partners. Subscribe to Neowin - for $14 a year, or $28 a year for Ad-Free experience Disable Sponsored posts · Neowin Deals · Free eBooks · Neowin Store

      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.