Connection problem with ADO.NET

[former_member1199283]

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".

But in the Advanced Tab is no option to activate SSL.

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.

[former_member1199283 · Accepted solution]

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.