Have you unblocked the required IP ports in Firewall?
See Configure the Windows Firewall to allow SQL Server access
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?
Have you unblocked the required IP ports in Firewall?
See Configure the Windows Firewall to allow SQL Server access
Windows firewall is not enough. You also need to go the blade for the VM in the Azure portal to open the port.
However, exposing an SQL Server instance with a public IP is a lousy idea. There will be lot of folks knocking on that door trying to get in. You need to set up a private network so you can connect with VPN.
How do that? Cough, I don't really know. I create a VM for a test last night and I set up a public IP - but I also deleted the VM directly since it was for a quick test.
Hi @Gurpreet Khaira,
Please check the documentation step by step.
Connect to a SQL Server virtual machine on Azure
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.