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 réponse
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
répondu il y a 2 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions