I cannot connect locally from my laptop using SQL Server Management Studio, but does not work from OutSystems Service Center > Database Connection
Can you elaborate more on the issue/error ?
Yes. I can access my SQL Server on AWS via SQL Sever Management Studio but cannot access it from Service Center > Administration > Database Connections on OutSystems cloud
Kaushal Shah wrote:
Hi Kaushal,
I am able to connect with MSSQL server via using a Outsystems service center. Please see the screen-shot.
If you are facing any other issue in connectivity then please share.
Jitender Gaur wrote:
Hi Jitender,
What is the value we have to put in "Server"? It is database server IP, right? If i not wrong.
Is there any configuration that will be need from the AWS RDS side?
Thanks...
Could you please share the solution for this incase if you have found as I am facing the same issue.
Hi All,
We have an created a database in aws cloud and we are trying to connect it from Outsystems Personal environment. We have made DB as publicly accessible, but we are getting timeout. Can anyone help?
Thanks,
Ankitha
Hi,
I'm also facing issue when trying to connect to any DB / DB hosted in Cloud. Is secure network / Dynamic Ip be one of reasons for the failure in connectivity? Please let us know your opinion on the same issue.
Thanks in advance.
-Anup Sagar G
Hi Anup Sagar G,
Yes, absolutely. Dynamic IP is a very common cause of connection failures.
AWS Security Groups act as a strict whitelist. If your public IP changes (which happens frequently with Dynamic IPs), the AWS firewall will block you immediately. You must update the Inbound Rule in your AWS Security Group with your current IP every time it changes.
Also, regarding "Secure Networks," strict corporate firewalls often block outgoing traffic on port 1433. You might need to check with your network admin or try connecting from a different network to verify.
Hope this helps!