Forum Discussion

coneslager's avatar
coneslager
New Member
9 years ago

Problem with on-premise gateway

We have had the gateway working for months, but something has changed.  We have SQL Server on one vm in Azure and the gatewway running on a seperate vm in Azure as well.   The gateway appears to be c...
Need Help
coneslager's avatar
coneslager
New Member
9 years ago

I do have SSMS installed on the same server that the gateway is installed on  and it can connect to the database just fine on the other vm.  This should remove any concerns over networking.

 

The error message I get on the orignal server, the actual db server, that was running the gateway was at the bottom of the original post. 

The on-premises data gateway installer failed to download install.  (Sorry for the wrong word).
The client and server cannot communicate, because they do not possess a common algorith.  This is after making a few security changes including turning off ssl3, tls 1.0, 1.1.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi coneslager,

Please ensure that you add all required ports in firewall following the guide in this article, and you install the latest version of gateway on another VM.

Besides, do you use proxy in this sceanrio? Which type of authentication do you use when adding SQL Server data source under gateway?




Thanks,
Lydia Zhang