Unable to remotely access SQL server 2019 on Azure Virtual Machine

Question

Hello,

I am trying to trying to connect to SQL server on the Azure Virtual Machine remotely through my local SSMS but, I am not able to connect,
it says server not reachable ,

What I have tired is -
Open port on VM network configuration ,inbound and outbound
tried Win 10 Pro firewall port open ,inbound and outbound

set SQL server configuration manager IP address to 1433 to all
enabled named pipe configuration

Still not able to connect.

Any help would be appreciated .
Thanks

Answer 1

If you install the sql server 2019 manually in a windows VM in Azure.
To check the connection from external internet, do the following things:

1. Enable the sql port 1433 from your external ip address in Azure vm network security group.
   
2. In your vm, run ssms, try to connect the sql service by private ip address ( 10.1.0.X ... ) , if failed with same error, mostly because it is the TCP/IP protocol is not enabled in sql service
3. Check SQL Server configuration Manager, Enable the tcp/ip protocol. And restart the sql service, then try SSMS to connect the sql service by private ip address
   
4. Then, you can connect the sql server sql service by Sql server management studio or Azure Data Studio from your home/office.

Answer 2

... and that SQL Server is configured to allow remote connections.

And, are remote connections allowed? E.g. SQL Server Express don't allow remote connections by default.

Answer 3

Hi,

Please try to refer to this official document to check if there is anything you haven't noticed.

Connect to a SQL Server virtual machine on Azure

If this VM is not a SQL Server virtual machine, but a Windows VM with SQL Server manually installed,you may also need to allow connections to ports that SQL Server is listening on from the Azure portal.

SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop