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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi coneslager,

Are you able to connect to SQL Server using SSMS installed in the Azure VM that is running gateway? Based on your description, the gateway shows good status, but you get the above error when adding SQL Server data source, right? If that is the case, the issue could be caused by the network between the two Azure VMs, I would recommend you contact your network team to troubleshoot this issue.

In addition, what error message do you get when downloading on-premises data gateway in Azure VM?


Thanks,
Lydia Zhang

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