Azure and locked down RDP conenctions

Published 11 years ago

Hi All,

I have the DB in Azure, now have Azure RemoteApp setup with RDM running and talking to the Azure DB.

Problem I am facing is we have our remote connections locked down by our external IP, when connecting from azure I'm not coming from our IP but an Azure IP so I can't connect.

my question is can I route the traffic via our network?

I remember seeing something about an agent? but I'm not sure if this is the same thing?
Thanks James.

All Comments (3)

David Hervieux

Published 11 years ago

Hi,
This is more a general question. Let me know if you find a solution outside of RDM and we will do our best to integrate it.

David Hervieux

James Dyke

Published 11 years ago

Could there be anyway of you guys making a connector to run on our site on a server then make a setting in RDM that forces the traffic via your connector?
James.

Stéfane Lavergne

Published 11 years ago

Writing a SQL proxy wouldn't be a trivial thing to do. There might exist such a product, you could Google it. Keep in mind that with this type of solution you would incur extra bandwidth cost from Azure (from SQL -> local then local -> remoteapp) Not a big deal but something to keep in mind.

You might have other options. You could try using Azure virtual networks and link private (local) network with Azure. With this you might be able to route all the SQL traffic via your own network back to Azure SQL. Not sure how you would actually accomplish this but with some research you should be able to figure it out.

Another option would be to use RDMS (Remote Desktop Manager Server) locally, referencing back to the SQL Azure and than have the RemoteApp reference the RDMS. Same as using a "SQL proxy"costs will apply and you need to purchase a subscript of RDMS.

Lastly you could use our private cloud offering RDMO (Remote Desktop Manager Online) to store your data instead of Azure SQL.

Best regards,

Stéfane Lavergne