0

I have created the virtual machine on Azure and installed a free version of the SQL Server database. I have created a new login in the SQL Server to access the database. I also added the inbound rule to enable TCP port on the Azure portal of the virtual machine.

enter image description here

Now I am trying to access the SQL Server instance from my local computer over IP but it's not connecting. Is there anything I am missing? I am getting this error:

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Imran Ahmad Shahid
  • 793
  • 8
  • 29
  • 1
    Your screenshots do not help, remove them. What is the OS? How is the OS firewall configured? How is the Azure firewall configured? What network interface is SQL Server listening on and the port number? Do not comment, edit your question with details. – John Hanley Jul 12 '21 at 23:18
  • Does this answer your question? [Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?](https://stackoverflow.com/questions/18060667/why-am-i-getting-cannot-connect-to-server-a-network-related-or-instance-speci) – Charlieface Jul 12 '21 at 23:44

1 Answers1

3
  1. Use Configuration Manager to enable TCP/IP connections and listen on port 1433.
  2. Add a Windows Firewall rule allowing inbound traffic on port 1433.
  3. Configure the VM's Network Security Group to allow inbound traffic on port 1433.
David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67