Question Re: service through https in Technology Q&A

service through https

former_SQLA_member1694909 — Tue, 19 Dec 2017 08:53:17 GMT

We create a service (CREATE SERVICE ws_getAnimalData TYPE 'XML' AUTHORIZATION OFF USER DBA AS SELECT..).

The protocol we want to use is https. We have bought a Comodo Server Certificaat, instant ssl. This is already installed in IIS (server certificates) and used by other webservices developed in c#.

Is it possible to use this certificate also for SQL anywhere 12? If so, what should we do to get it up and running?

Please consider in your answer that I don't know anything about certificates and there differences.

Thanks Eric

Re: service through https

Vlad — Tue, 19 Dec 2017 10:51:36 GMT

I don't know your infrastructure, and thus I can only assume what you have. If you have a single certificate, it means that you have it probably per domain name (e.g. www.example.org). The easiest solution would be to use HTTP on SA, but use IIS as the firewall/proxy in front of SA.

If you want to enable HTTPS for CREATE SERVICE, you should use SECURE ON attribute. But you have to provide HTTPS option to -xs when you start dbsrv (http://dcx.sap.com/index.html#sqla170/en/html/3bcf15226c5f10149412f9b3a04b6c6b.html )

Re: service through https

VolkerBarth — Tue, 19 Dec 2017 11:11:43 GMT

See this FAQ by Mark how to setup a SA https web service.

Re: service through https

former_SQLA_member1694909 — Wed, 20 Dec 2017 06:02:17 GMT

When we use the -xs option is "Identity" the certificate filename we bought? Is "Identity_Password" the password used to create the certificate?

The problem is that someone else created the certificate for us. I also asked him this question but he could not give the answer?

Re: service through https

VolkerBarth — Wed, 20 Dec 2017 07:11:59 GMT

Yes, and the password is that for the private key.