How To Connect ASP.NET Application with AWS Database

Поделиться
HTML-код
  • Опубликовано: 15 окт 2022
  • In this tutorial, we show how to create Microsoft SQL Server instance on AWS cloud platform, Connect the AWS Database instance from local client, create new database and finally connect the database to fetch records and display using ASP.NET MVC Application (.NET 6)
    This video provide good understanding on working with AWS cloud database and connectivity from ASP.NET application.
    Thanks for visiting Digital TechJoint Channel and we wish all the very Best Learning experience .
    Please do Subscribe, Share and like our videos
    Below are the links of Video that will help further in learning ASP.NET.
    Good Luck !!! Keep Learning
    How To Deploy ASP.NET Appliction on AWS Cloud Platform
    • How to Deploy ASP.NET ...
    How To Apply Free Bootstrap in ASP.NET Application
    • How To Apply Free Boot...
    Razor Pages Complete Course Dotnet Framework 6.0
    • Complete Course on Raz...
    Complete Course in ASP.NET MVC 6.0
    • Learn ASP.NET MVC (.NE...
    How to Setup Amazon AWS Free Account
    • How to Setup Amazon AW...
    AWS Secure Root User Using Identity Access Management Service (IAM)
    • AWS Secure Root User U...
    Intro To ASP.net CORE
    • How To Create Web API ...
    How To Upload Images in Database ASP.NET Razor Pages
    • Razor Pages - How To U...
    Dependency Injection Explained
    • How To Implement Depen...
    ASP.net CORE Using ADO.net
    • How to use ADO.NET in ...
    Repository Pattern Explained
    • How To Implement Repos...
    Getting Started with Razor
    • Getting Started with R...
    Working with Images
    • How to Upload Images U...
    Razor Page Short Videos Playlist
    • Learn ASP.NET Razor Pa...
    Complete ASPNET MVC Course
    • Learn ASP.NET MVC (.NE...
    AWS S3
    • Playlist
  • НаукаНаука

Комментарии • 23

  • @AbuSayed-gf8gt
    @AbuSayed-gf8gt Год назад +3

    Good tutorial for learning about MSSQL Server database connect to AWS.

  • @singhranavlog
    @singhranavlog 11 дней назад +1

    Great tutorial towards AWS journey. I created database on AWS as per you suggested, on local Sql Server Management Studio I'm not able to connect to db its throwing error.
    I have checked below things:
    1. Checked as Publicly accessible
    2. Copied the endpoint and place in local ssms follwed by comma and port 1433.
    Can you please suggest the cause behind this. I followed video twice but still no luck.

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  10 дней назад

      Thanks for you comments. Please make sure you have setup the Inbound rules with the defined MSSQL port. Also, make sure your local PC firewall is not blocking the connectivity to DB instance on AWS .. If you still face the exception then request to share the screenshot on my email addresss. Will surely help you out to sort your issue. thanks

  • @healmist5721
    @healmist5721 Год назад +1

    Great !thank You for Valuable content! Subbed!

  • @meetgurl
    @meetgurl Год назад +1

    this is helpful! thank you man !

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  Год назад

      Really Appreciate your feedback. we have tutorials to deploy ASP.NET application on MS Azure also. Please do watch and comment. Thanks

  • @harshilgandhi4397
    @harshilgandhi4397 9 месяцев назад +1

    I already have Sql server database hosted on Linux server
    Now, I have deployed API on ANOTHER Aws server.
    IN Local Microsoft Visual Studio 2022, I am able to connect to Database hosted on AWS.
    After Hosting .net core API on another server in which AppSettings file, I have mentioned URL, ID and password of DB settings - But I am not able to connect to DB

  • @lookylooks3977
    @lookylooks3977 Год назад +1

    Saved me brodda :D

  • @informer9261
    @informer9261 5 месяцев назад

    Sri make an video how to deploy aap net core web api with sql server database

  • @lukatomic6294
    @lukatomic6294 Год назад +2

    Hey man, great channel! Your tutorials are amazing. I am getting a connection error when I try to connect via MSSM. Is there anything that needs to be set to public, or some windows settings which prevent me in conecting to db?

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  Год назад +1

      Thanks for your comments. Make sure you have allowed the Access for MSSQL port in AWS and while connecting from your local MSSQL to AWS use the port if required. All this I have shown in the Tutorial. Suggest to go through the video once again. I am sure you are missing something very minor .. Thanks

    • @lukatomic6294
      @lukatomic6294 Год назад +1

      @@DigitalTECHJOINT It has been resolved by adding the IP access to MSSQL! Keep up the good work

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  Год назад

      @@lukatomic6294 Great !!! Glad to know that 🙂

    • @starr_lord0
      @starr_lord0 Год назад

      I'm not able to connect even I tried 2 times and also enable TCP/IP Connection, please help

    • @lukatomic6294
      @lukatomic6294 Год назад

      @@starr_lord0 Go to your AWS management console and open EC2. On left you need to scroll until you find "Network and security". Pick Secuiry groups from that dropdown. Click on one with "default" under Security group name. Add a new inbound rule for it. Type: all traffic and source "My ip"

  • @abhaykumarkanaujia
    @abhaykumarkanaujia Год назад +1

    I created db but for some reason i am not able to connect from sql server management studio

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  Год назад

      Please watch the video again. I am sure you are missing some steps. Have you provided public access to your DB created on cloud ? THanks

  • @tapasmondal8993
    @tapasmondal8993 Год назад +1

    Thank you for this video. could you pls send me windows authentication connection string

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  Год назад

      Thanks for your comments. We did not get your request. Do you want the source code ? Pls drop email we will share across . thanks

  • @sspynr2273
    @sspynr2273 Год назад +1

    Is MS SQL SERVER AVAILBALE IN FREE TIER TO USE FOR CERTAIN PERIOD FOR TRIAL AND TEST

    • @DigitalTECHJOINT
      @DigitalTECHJOINT  Год назад

      Yup!!! It is available in Free Tier .. If you concern is usage then make sure you select minimum resource for setting up MS SQL server and keep track of usage using CloudWatch and Make sure you setup Payment Limits /Threshold using the Budget Service (You will receive alerts) . Also simple things like you can keep the DB instance stopped if not using it while you are learning AWS .. Hope it helps . Thanks for visiting Digital TechJoint. . Take Care