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

asked 19 Dec '17, 08:53

ontsnapt's gravatar image

ontsnapt
51226
accept rate: 0%

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 )

(19 Dec '17, 10:51) Vlad
Replies hidden

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

(19 Dec '17, 11:11) Volker Barth

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?

(20 Dec '17, 06:02) ontsnapt

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

(20 Dec '17, 07:11) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×14

question asked: 19 Dec '17, 08:53

question was seen: 89 times

last updated: 20 Dec '17, 07:11