I am experimenting with XData server running on Azure hosted machine. This is connected to a MSSQL database also in Azure.
I have this running and have exposed some data which I can GET from a simple Web Client running default on localhost:8000.
I want to host my WebApp on Azure and sftp the required files to site/wwwroot everything runs fine UNTIL I try to connect the WebApp to the XData service where it fails to connect with this:
XDataConnectionError: Error connecting to XData server | fMessage::XDataConnectionError: Error connecting to XData server FJSError::Error: XDataConnectionError: Error connecting to XData server fHelpContext::0
at https://imlweb.azurewebsites.net/webProject.js [79489:13]
For the life of me I CANNOT get HTTPS to work for me. I have secured my azure XData client, assigned custom domain name and added SSL.
However, I just can't get the SSL bindings to work on the VM that hosts the XDataServer. I am aware that this is probably outside the scope of TMS support but I have so many apps that are still using a direct connection to SQL server and I have struggled with this for a couple of years I am hoping another customer has the resolution, I know I am close.....
If I leave everything as HTTP it works so I know my connections work.
Last piece is adding the SSL to the public IP on the Azure VM, this has no DNS entry, I can then amend the app components to look at https.
HOPEFULLY someone has cracked this.
Having looked at all of this I finally managed to get the setup to work by deleting all certificate entries and rekeying my GoDaddy certificate with a CSR generated through the certlm MMC snap-in. For future reference, both mine and any other users, here are the basic steps to generate and install a working SSL certificate on an Azure VM with public IP:
Assign a domain name to the public IP
In MMC navigate to Certificates - Local Computer\Personal\Certificates
Right click select AllTasks/Advanced Operations/Create Custom request > Next
Select Custom Request\Proceed without enrollment policy > Next
Select (No Template) CNG key and PKS#10 > Next
Add a friendly name (I used domain name) and description