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 |
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 )
See this FAQ by Mark how to setup a SA https web service.
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?
Yes, and the password is that for the private key.