Please Explain SQL Server 2017 Connection With Outsystems Framework

I am not able to connect outsystem with sql server 2017.


if anybody knows the answer please explain.


Thanku in Advance.

Hi Rohan,


What is the version of Outsystems you are using? SQL 2017 is supported by Outsystems 11 but i dont think its supported by Outsystems 10.

Also details would help to solve this issue.


Thank you,

Alefiya

Alefiya Ali wrote:

Hi Rohan,


What is the version of Outsystems you are using? SQL 2017 is supported by Outsystems 11 but i dont think its supported by Outsystems 10.

Also details would help to solve this issue.


Thank you,

Alefiya


Hi Alefiya,


I am using Outsystem 11.


And the problem is i am sharing you screenshot.

Hi Rohan,

Can you describe what error you are getting.

Have you follow this document

https://success.outsystems.com/Documentation/11/Extensibility_and_Integration/Integrate_with_an_External_Database


Regards

Rahul Sahu

So this is the error i am getting.

rohan goyal wrote:

So this is the error i am getting.


Look like you have some problem with your credential.
Could you please try to test connection using Configuration Manager 

Salman Ansari wrote:

rohan goyal wrote:

So this is the error i am getting.


Look like you have some problem with your credential.
Could you please try to test connection using Configuration Manager 


please can you explain how to test connection using configuration manager.

Hi Rohan,

I notice that in your connection string is mentioned DESKTOP-..... and that your OutSystems is a personal cloud environment.

So unless your Desktop is reachable from the internet, OutSystems will not be able to connect to it. And that is what your error message is telling you. 

You can only connect from a PaaS OutSystems directly to an external database on your own network if you set up a VPN connection between OutSystems and your internal network.However, this is not possible from an OutSystems personal environment.

Consider hosting your SQL Server on for example Azure. Then it will be possible.

Regards,

Daniel