https://community.sap.com/t5/technology-q-a/connection-problem-with-ado-net/qaa-p/680896#M180626 <P>The problem was Visual Studio 2017. After installing Visual Studio 2015 i was able to choose my ODBC data source as host which had ssl activated.</P> Tue, 06 Nov 2018 06:44:37 GMT Former Member 2018-11-06T06:44:37Z https://community.sap.com/t5/technology-q-a/connection-problem-with-ado-net/qaq-p/680895 <P>Im trying to setup Entity Framework with a SAP Hana Server. It worked fine until our server admin activated SSL on the server. Now when i try to connect with the server explorer it says: "only secure connections are allowed".</P> <P> </P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/238580-secure.png" /></P> <P> </P> <P> </P> <P>But in the Advanced Tab is no option to activate SSL.</P> <P> </P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/238581-advanced.png" /></P> <P> </P> <P> </P> <P>I can connect with Entity Framework when i edit my ConnectionString in my App.Config by adding "ENCRYPT=true;sslValidateCertificate=false", but im unabled to generate new DbSets because there is no option in the wizard to add these properties.</P> Mon, 05 Nov 2018 12:33:09 GMT https://community.sap.com/t5/technology-q-a/connection-problem-with-ado-net/qaq-p/680895 Former Member 2018-11-05T12:33:09Z https://community.sap.com/t5/technology-q-a/connection-problem-with-ado-net/qaa-p/680896#M180626 <P>The problem was Visual Studio 2017. After installing Visual Studio 2015 i was able to choose my ODBC data source as host which had ssl activated.</P> Tue, 06 Nov 2018 06:44:37 GMT https://community.sap.com/t5/technology-q-a/connection-problem-with-ado-net/qaa-p/680896#M180626 Former Member 2018-11-06T06:44:37Z