|
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 |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 19 Dec '17, 08:53
question was seen: 1,228 times
last updated: 20 Dec '17, 07:11
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.