CODEWITHSUNDEEP
sql-serverazurevirtual-machineazure-virtual-machineazure-virtual-network
Imran Ahmad Shahid
Imran Ahmad Shahid

Reputation: 822

Access self-installed instance of SQL Server from Azure Virtual Machine

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

Upvotes: 0

Views: 541

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89256

  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.

Upvotes: 3

Related Questions