Share via

Best way to connect a desktop aplication to a AZURE VM Windows Server (SQL Database)

Ricardo Silva 21 Reputation points
2023-01-10T19:12:26.623+00:00

I have a VM Windows Server 2019 on Azure with an SQL Database, I need my users to access to that server from the client application. (5 users)

Whats the best (safer\reliable) way to give end users access? (trying not to give them direct access to the SQL server thru RDP) (Internet connection is going to be slow)

1 - Add RDS Server? 2- Add an Azure virtual desktop for each user and configure it to on the same network has the server? 3 - Any other option you guys cat think of.

Thank you and best Regards

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
9,035 questions
Accepted answer
  1. JimmySalian-2011 42,496 Reputation points
    2023-01-10T19:48:42.967+00:00

    Hi,

    I would suggest you try out Azure Virtual Desktop though this will cost you license and hosting cost in Azure, also check out this page it has some options listed here.

    Hope this helps. JS

    == Please Accept the answer if the information helped you. This will help us and others in the community as well.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,921 Reputation points
    2023-01-11T01:34:46.393+00:00

    Hi @Ricardo Silva

    Why not just connect the client application on the users' device with that database?

    1.) You can configure a DNS name for the VM https://learn.microsoft.com/en-us/azure/virtual-machines/create-fqdn an older version with screenshots => https://azurelessons.com/azure-virtual-machine-dns/

    2.) try to connect from your local PC with SQL Server Management Studio (or any other tool) 3.) Configure the application to use the DNS of the VM for the connection ... something like mySQLVM.westus.cloudapp.azure.com\SQLExpress (Servername\Instancename - depending on your SQL installation

    It sounds like you might not need any more service as your app just wants/needs to connect to the database maybe - to make it a little more secure - you should think about (and deploy) a VPN connection. https://learn.microsoft.com/en-us/azure/networking/working-remotely-support?toc=%2Fazure%2Fvpn-gateway%2Ftoc.json

    I hope my answer is helpful to you,

    Your Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

  2. Limitless Technology 44,766 Reputation points
    2023-01-12T16:53:32.4+00:00

    Hi,

    Thank you for posting your query.

    Kindly follow the steps provided below to resolve your issue.

    This topic describes how to connect to your SQL on Azure virtual machine (VM). It covers some general connectivity scenarios and then provides steps in the portal for changing connectivity settings. If you need to troubleshoot or configure connectivity outside of the portal, see the manual configuration at the end of this topic.

    If you would rather have a full walkthrough of both provisioning and connectivity, see Provision a SQL Server virtual machine on Azure.

    Go to this link for your reference and other troubleshooting procedures https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/ways-to-connect-to-sql

    Do not hesitate to message us if you need further assistance.

    If the answer is helpful kindly click "Accept as Answer" and up vote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.