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.
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
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
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?
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
@@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"
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
![Twenty One Pilots - “The Line” (from Arcane Season 2) [Official Music Video]](http://i.ytimg.com/vi/E2Rj2gQAyPA/mqdefault.jpg)
Good tutorial for learning about MSSQL Server database connect to AWS.
Good tutorial! Thanks
Great !thank You for Valuable content! Subbed!
this is helpful! thank you man !
Really Appreciate your feedback. we have tutorials to deploy ASP.NET application on MS Azure also. Please do watch and comment. Thanks
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.
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
Saved me brodda :D
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
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?
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
@@DigitalTECHJOINT It has been resolved by adding the IP access to MSSQL! Keep up the good work
@@lukatomic6294 Great !!! Glad to know that 🙂
I'm not able to connect even I tried 2 times and also enable TCP/IP Connection, please help
@@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"
Thank you for this video. could you pls send me windows authentication connection string
Thanks for your comments. We did not get your request. Do you want the source code ? Pls drop email we will share across . thanks
I created db but for some reason i am not able to connect from sql server management studio
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
Sri make an video how to deploy aap net core web api with sql server database
Is MS SQL SERVER AVAILBALE IN FREE TIER TO USE FOR CERTAIN PERIOD FOR TRIAL AND TEST
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