service through https

[former_SQLA_member1694909]

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

[Vlad]

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 )

[VolkerBarth]

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

[former_SQLA_member1694909]

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?

[VolkerBarth]

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