Connecting to AWS RDS SQL Server from Appsmith

0

Hi there. I just created an AWS account and an RDS SQL Server database intended for some quick "proof of concept" work but I can't seem to successfully connect to it from Appsmith. I simply created the database with "default" settings aside from going back and making sure that it was publicly accessible - should that not be enough to be able to connect to it from outside, using the endpoint as my host address, port specified as 1433 and the username and password that I assigned? I'm getting the "server was not found or was not accessible" message. I did find that I had to add an inbound rule for my default security group for MSSQL of CIDR block 0.0.0.0/0 in order to successfully connect via SSMS, so I tried similarly adding inbound rules with CIDR blocks equal to the IP's that Appsmith uses but I'm still unable to connect from there.

I'm a real newbie to setting up an AWS environment, so apologies there... again, I was just hoping to use if for a quick proof of concept but my inability to connect is throwing a wrench in that idea.

Thanks.

1개 답변
0

You can refer How do I resolve problems when connecting to my Amazon RDS DB instance?. Based on the connectivity error message you can troubleshoot it.

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquires in repost, thank you ;)

AWS
답변함 2달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠